Originally Posted by TheBigBoss

Hi Jrod9190,

I do upload and retrieve files from on our Sharepoint.

I have added the Sharepoint site to our organisation "One Drive". To do so, go to your Sharepoint site then go to the file directory you use in Sharepoint and click on "Add shortcut to One Drive". You should see the directory in your C:/ under "One Drive".

You know have a link to C:/ pointing to your Sharepoint directory. You can now do whatever you want using simple VBA macro. Ensure all staff in your organisation does the same.

In VBA, you should use:
C:\Users" & Environ("UserName") & _
"\OneDrive - MyOrg\MYDIRECTORY\