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\

We don't have an organization One Drive. Instead every employee has their own personal personal drive.

Still, go to your Sharepoint library (usually called "Files")... but go on the web, not Teams. Look for "Add shortcut to OneDrive" and click on it; give it 5-10mn, it will add the directories (with a padlock icon next to it), As long as you have OneDrive, you are good to go, organisation or not.

Use your usual Files Browser and get the path.

Then in VBA, you now have a link in C to do whatever you want in shared environment.

Use Environ to get username.
C:\Users" & Environ("UserName") & _
"\OneDrive\MYDIRECTORY\