Function to retrieve UserName in VBA?

[brettatexplace]

Easy question, but I can find it in the help files. I want to get the userID name retrieved from the network login. Is it something like???

Dim strUserIs as String
strUserIs = Environ("UserID")

Thanks in advance!

 

[PHV]

strUserIs = Environ("UserName")

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

 

[markgrizzle]

search this forum for getusername

 

[PHV]

And for win9x:
strUserIs = CreateObject("WScript.Network").UserName

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

 

[brettatexplace]

Told you it was easy! Thanks everyone.