Macro Not working when I share with other co-workers

[RMONTE]

I have a simple macro that saves a sheet in the workbook as a PDF. It works perfectly on my computer but when I share with co-workers it doesn't work. It appears as though the ChDir is pointing to a path specific to my computer. Is there a way for that to be dynamic to the computer it's running on.
Here's that portion of the code:

ChDir "C:\Users\RMONT\Desktop"

 

[jproffer]

Maybe try this:

ChDir "C:\Users\" & Environ("UserName") & "\Desktop"

not sure, but it's worth a try...

 

[Fluff]

Another option

ChDir Environ("userprofile") & "\Desktop"

 

[jproffer]

UserProfile is a new one on me...good call.

I guess I should spend 10 seconds on google and find a list of all the environ arguments lol.