VBA & SharePoint?

[helen1977]

Is there a way to save an Excel file directly to SharePoint using VBA or maybe VB 6.0?

Basically, I have a process that manipulates some data in Access, saves the data to an Excel report, and then saves the report to a share drive. I now need to add in a piece of code that will also save the report to SharePoint.

Thank you

 

[helen1977]

Does anyone have any ideas for how to resolve this?

Thank you

 

[Darth Vodka]

http://blogs.msdn.com/access/archive/2006/09/18/761366.aspx

for 2007