How to change old Environ file path to work with one drive

[MZING81]

I had a number of workbooks that other co-workers use.
I have have vba code:

Workbooks.Open filename:=(Environ(“userprofile”) &

how do I convert that to work with One drive?
Unfortunately my dept. received no warning on this update from our higher ups so it’s reeking havoc with running van code.

many help is greatly appreciated!

 

[Marc L]

​

Map a drive to One Drive, to see with your IT …​

 

[daverunt]

Hi,

if you mean open files on local OneDrive folders on different PCs you need the User name folder in the path

C:\Users\<Username>\OneDrive\Documents\

Usr = Environ("UserName")

Workbooks.Open "C:\Users\" & Usr & "\OneDrive\Documents\Test.txt"