Pushing data from Excel to SharePoint via VBA

roscoe

Well-known Member
Joined
Jun 4, 2002
Messages
1,026
I have an Excel data project that imports data from our company server, gonkulates it, then produces an output. Sometimes, an office within our company has to approve a step in the process. Up to now, that process has been via email, so I developed a means via VBA to populate, address, and add the user's signature to an email. All he had to do was hit send...

However...that office has suddenly decided to use a SharePoint form to enter the relevant data requiring approval instead of email. I'd like to (using VBA) create a new form and then populate it, leaving the user to hit "Submit". Unfortunately, the inner workings of SharePoint is totally foreign to me, and none of the local SharePoint power-dudes have used VBA anywhere to automate anything. I'm looking for ideas on where to start...

Thanks!
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,141,072
Messages
5,704,133
Members
421,329
Latest member
mippy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top