Environ for vba

Question

I am looking for so good information or code examples of the environ function for vba to grab the username on the current system.

Answer 1

Environ() gets you the value of any environment variable. These can be found by doing the following command in the Command Prompt:

set

If you wanted to get the username, you would do:

Environ("username")

If you wanted to get the fully qualified name, you would do:

Environ("userdomain") & "\" & Environ("username")