Button to go to desktop from form

I tried this
Application.FollowHyperlink Environ$("BBryan") & "\Desktop\"
And This
Application.FollowHyperlink Environ$(BBryan) & "\Desktop\"

And it didn't work...

Thanks BBryan

I meant with the username variable like this

Application.FollowHyperlink "C:\Users\" & Environ$("UserName") & "\Desktop\"

I just would like to see if the $ suffix makes that difference.?
 
I tried these and it doesn't work
Application.FollowHyperlink "C:\Users\" & Environ$("UserName") & "\Desktop\"
Application.FollowHyperlink Environ$("UserName") & "\Desktop\"
Application.FollowHyperlink "C:\Users\" & Environ$("UserProfile") & "\Desktop\"

But this works
Application.FollowHyperlink Environ$("UserProfile") & "\Desktop\"


Thanks BBryan
 

Users who are viewing this thread

Back
Top Bottom