Environ variables

[Shift838]

Where can I get a complete listing of all the Environ variables that can be used in VBA?

 

[PHV]

Open a console window and type set

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Shift838]

thanks, I was really hoping that MS had one for like full name or display name. Guess UserName will have to work.

Chris

 

[PHV]

Another (VBA) way:
i = 1
Do
EnvString = Environ(i)
If EnvString = "" Then Exit Do
Debug.Print EnvString
i = i + 1
Loop

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886