Using Excel VBA to create files and folders in SharePoint Online

scram28

New Member
Joined
Jun 17, 2022
Messages
1
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
My company would like to move from DropBox to SharePoint Online (locally sync'd) for our everyday shared file storage. My Excel VBA programs create files and subfolders. In Dropbox, this isn't an issue because the file path is "local" and the Dropbox sync service just "picks up" the new files and folders.

The problem I run into when trying to run these programs from the local SharePoint Online sync is that the file path is the "web URI" to the file. Has anyone else tackled this issue of creating or modifying files and folders in the local sync for Sharepoint Online?

Is there a way to find the "local path" so I can operate locally and let the file sync do the work?
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Forum statistics

Threads
1,223,604
Messages
6,173,315
Members
452,510
Latest member
RCan29

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top