Copy binary files to/from Sharepoint 2010 using VBA?
Posted on 2011-02-14
I have a hybrid Sharepoint 2010/Access 2010 application that is managed/distributed via SharePoint 2010 but runs on the user's workstation (it is code-intensive and cannot run in SharePoint).
The first time a user copies the application to the workstation and executes it, a set of folders is created on the user's C: drive, into which a number of binary files need to be copied from a Sharepoint library.
Once the user's environment is set up, the product of executing the application, which is a production app that runs daily, is a set of xml and html pages that are copied to a Sharepoint library specified by the user.
Can anybody point me to a good way to manage these copy operations within the Access app in VBA?