Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Microsoft SharePoint _ Create Sharepoint Folder From Vba (access 2016)

Posted by: Pat_M Oct 12 2019, 06:53 AM

I am a newcomer to SharePoint Online and I am trying to add a subfolder to a SharePoint Document Library from Access 2016 using VBA.

This recent post seems to be exactly what I need:
https://stackoverflow.com/questions/58243289/create-sharepoint-folder-from-vba-access-2016

Could anyone give a fuller example of the code needed to achieve this?

What API do I need to reference and how.
What references do I need in the access database: Microsoft Scripting Runtime, Microsoft XML, V6.0, VBA-JSON v2.3.1 module?
Also what URL I would need to specify if the top level documents are located in this type of path:
https://SampleName.sharepoint.com/sites/sitename/Shared Documents/

Thank you.

Posted by: chrismbaylis Oct 15 2019, 10:16 AM

Hey Pat - out of interest, is the Sharepoint folder synched to a local directory? If so, creating the new folder locally would then force it to be synched to Sharepoint - far simpler using FileSystemObject or a number of other approaches.