Microsoft Office Tutorials and References
In Depth Information
DISCOVER THE TEMP FOLDER PATH
Each entry in the list contains the environment variable name, an equals sign,
and the value on that computer. When you know what variable names are
available, you can pass the variable name in quotes:
Msgbox "You are signed in as " & Environ("USERNAME") & " to
domain " & _
Some common environment variables that appear on most systems include:
Additional Details: The Environ function does not work in the Excel grid.
You can build a user-deﬁ ned function to make it available to the Excel interface.
To do so, use this code:
Function MyEnviron(ByVal Key)
MyEnviron = Environ(Key)