[X]My Assistant

[Pat_M]

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/5824328...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.

[chrismbaylis]

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.