Read Environment Variable? v2003

[oneilldm]

Is there a way to read in a system Environment Variable?

If I go to a command prompt and type "SET" the system will display all my Environment Variables. For convenience, I'd like to identify the User.

Thanks

 

[pbaldy]

Look at the Environ() function, or:

http://www.mvps.org/access/api/api0008.htm

 

[oneilldm]

Thank you... that's perfect!!!

This is the best Access help forum I've seen!

Thanks to all the contributors!

 

[Simon_MT]

You can also use:

Function GetWinUserName()
    GetWinUserName = VBA.Environ("UserName")
End Function
 
Simon