VBA: how do I get full user name, not login ID?

[mthompso]

The following VBA code, executed on a Windows Network computer, will give me the Windows Login ID of the user that's logged in to the computer:

Sub UserName()
    MsgBox Environ("username")
End Sub

How do I get the full user name, not just the Windows Login ID?

Example: On this specific Windows network, the login id is the first letter of the user's first name followed by their last name. John Doe's login id is JDOE. How can I get VBA to give me the string "John Doe" and not "JDOE"?

 

[Maximus Tatius]

Thank you very much! I was looking for a long time how to pull the username windows, and finally found! <3 <3 <3

I also just tried that and it worked... but it was very slow (3-4 seconds)

I also just ran MsgBox Application.UserName in the immediate window and it displayed my office user name straight away.

Maybe I'm misunderstanding the question, but Application.UserName seems to do exactly what I was looking for.