How to use System Variables?

[vbmanchris]

Hello,

I am trying to use a system variable to determine and set the path to an export file that my VBA code is creating. What variables can be used in VBA to set the path to the user's desktop, or the Windows directory, for example?

Obviously, "C:\Windows\Desktop" isn't going to work on W2K or NT, like it does on Win98.

Thanks,

Chris

 

[KyleS]

I've been using this for some time now on NT 4.0

"C:\Winnt\profiles\" & Environ$("UserName&quot & "\Desktop"

The Environ$("UserName&quot function will return the username of the person logged in at the time.

Assuming of course the path to your desktop is
"C:\Winnt\profiles\Chris\Desktop" Kyle