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\