You are here:

Excel/Link between Excel data and Sharepoint using VBA Codings

Advertisement


Question
QUESTION: Hi

This is Gayathri from Chennai, India. I prepared excel sheet, in which data is getting added by using vb coding. i just want to move those data to share point. the data is entered by user daily and it has to be added in to share point by using vb coding. in simple words, if we click on a single button, the excel data has to be moved to share point. is that possible? can you help me on this?

Regards
Gayathri

ANSWER: Hi what you want to do is save the workbook in a shared folder?
you should put this in the button code

ActiveWorkbook.SaveAs Filename: = "C: \ mydire \ myfile", FileFormat: = xlsm

Look at this example
http://www.programarexcel.com/2013/05/crea-carpetas-y-guarda-archivo-con.html

In http://programarexcel.com examples can download free excel macros programmed in VBA, macros can be downloaded and adapted to the project that you're doing to automate excel.

---------- FOLLOW-UP ----------

Link between Excel data and Sharepoint using VBA Codings
Link between Excel dat  
QUESTION: Hi

Thanks a lot for your reply.

Please find the below questions.

1. I have mentioned few column titles in Excel sheet like Team Name, Activity, Start Time, End Time, Status, Comments, Elapsed Time, Productivity and Non-Productivity.

2. When I run VBa, the inputs from User will add in excel sheet row by row.

3. At last those data has to be added in share point by clicking on single button which we placed in VB form.

4. The data has to be added in share point whenever the User uses the sheet. The sheet is going to be used by User daily.

5. Most of the users going to use the sheet and all those data have to be added in share point as excel sheet or only data.

I am really very thankful for your effort and please advise me on the above.

Regards
Gayathri

ANSWER: hello up your file from www.programarexcel.com / p / contact.html

I see and send it to you with the answer, please add the details of what you need exemplifies.

www.programarexcel.com visit macro examples free download

---------- FOLLOW-UP ----------

Sharepoint
Sharepoint  
QUESTION: Hi

Thanks for your reply mail.

I don't want to save the file in the folder. I would like to move the excel data into my SharePoint.

My Sharepoint: http://ent12.sharepoint.hp.com/teams/gaya3/SitePages/Home.aspx

Note: The moved file in sharepoint has to be altered daily since the user going to use it daily.

Thanks

Answer
 hello
  with the following code and save the workbook in sharepoint public, you must adapt the url

ActiveWorkbook.ServerViewableItems.DeleteAll
   ActiveWorkbook.ServerViewableItems.Add ActiveWorkbook.Sheets("Hoja1")
   ActiveWorkbook.ServerViewableItems.Add ActiveWorkbook.Sheets("Hoja2")
   ActiveWorkbook.ServerViewableItems.Add ActiveWorkbook.Sheets("Hoja3")
   ActiveWorkbook.SaveAs Filename:= _
       "C:\Users\MyNotebook\Documents\Mis eBooks\MIS MACROS\Publicadas\499 Abre libro compartido copia datos y cierra  libro.xlsm" _
       , FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

visit:
www.programarexcel.com  
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


marcrodos

Expertise

Expert programming macros or visual basic VBA that can help automate your Excel spreadsheets using VBA programming or macros to excel, forms and other procedures related to Macros. I also have an excellent command of Excel in almost its entirety, formulas, graphs, dynamic tables. In http://programarexcel.blogspot.com o www.programarexcel.com examples can download free excel macros programmed in VBA, macros can be downloaded and adapted to the project that you're doing to automate excel www.programarexcel.com

Experience

For several years, use Microsoft Excel on a daily basis, more specifically in my work, which is why over several years I have compiled a wealth of knowledge about their operation, adding to the basic operation of coding excel VBA macros to automate repetitive tasks . I serve as an expert in excel also in www.todoexpertos.com site, which I enjoy a great reputation. In http://programarexcel.blogspot.com o www.programarexcel.com examples can download free excel macros programmed in VBA, macros can be downloaded and adapted to the project that you're doing to automate excel www.programarexcel.com

Organizations
http://www.programarexcel.blogspot.com http://www.programarexcel.com

Publications
In public http://www.programarexcel.com o www.programarexcel.com continuously macro examples that readers can download for free and adapt to the needs of each project in excel that has the web page visitor

Education/Credentials
My profession's is a Chartered Accountant with experience in Excel, especially in VBA or macro programming, but also in the formulas and everything related to excel, I graduated several years ago at the National University of Cordoba, now I practice my profession in which a basic tool is excel. www.programarexcel.com

Awards and Honors
http://www.programarexcel.blogspot.com http://www.programarexcel.com

Past/Present Clients
http://www.programarexcel.blogspot.com http://www.programarexcel.com

©2017 About.com. All rights reserved.