Open workbook from shared network drive

[mozza90]

Hi,

We have macros saved in a shared excel document. The majority of these macros open other docs saved in the network drive however currently the macros can only be used on my machine because of the path name i'm using. For example:

("C:\Users\HarryKane\Folders\Itscominghome.xlsx")

So obviously, this works on my computer, but won't work when my colleague Dele Alli wants to work on the file.

Do you know how I can change the "Harry Kane" to refer to whatever the username is on the current computer?

Thanks!

 

[admiral100]

Hi,

Try C:\Users\%USERNAME%\

 

[mozza90]

Thanks Admiral. This hasn't worked, it can't locate the file. Any other ideas?

 

[JazzSP8]

Is the username the same as the computer logon?

User = Environ("username")
("C:\Users\" & User & "\Folders\Itscominghome.xlsx")

 

[mozza90]

Yes, same as the computer logon. So that code works perfectly! Thank you very much

 

[JazzSP8]

No bother - Glad I could help