X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Create Sharepoint Folder From Vba (access 2016), Any Versions    
post Oct 12 2019, 06:53 AM

Posts: 1
Joined: 12-October 19

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:

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.
Go to the top of the page
post Oct 15 2019, 10:16 AM

Posts: 104
Joined: 25-March 10
From: St Albans, UK

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.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    4th July 2020 - 05:03 AM