VBA EXCEL - Default address for users

[ToseSenpai]

Hi all,

I have a file excel in my OneDrive, that I shared with others users.
We use this file together and I set some macro VBA into it.
I have a macro that run with some codes include this:
"C:\Users\myusers\OneDrive\Excel\File.xlsm"

Well, there is a way to change the part "myusers" with the default of the windows user?
Or there is a better way to do it?

Thank you very much for your help

 

[JW00]

Try Environ("USERPROFILE") & "\OneDrive\Excel\File.xlsm"

 

[ToseSenpai]

Try Environ("USERPROFILE") & "\OneDrive\Excel\File.xlsm"

Thank you very much

 

[JW00]

Glad to help, good luck with your project.