Pushing data from Excel to SharePoint via VBA

[roscoe]

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!