UtterAccess.com
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    
 
   
Pat_M
post Oct 12 2019, 06:53 AM
Post#1



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



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    10th December 2019 - 03:30 AM