How to get the current user

[davidgon]

Well, I want to get the current user of the computer by code. I thought it was going to be easy, but using CurrentUser, I get Admin, not my real username. Any idea?

Thanks!

[Surrogate]

try this

Code Select Expand

fGetUserName = VBA.Environ("UserName")

or this way

Code Select Expand

CreateObject("Wscript.Network").UserName

[wapperdude]

Similar to what Surrogate provided, see this forum post, scroll to bottom:  http://visguy.com/vgforum/index.php?topic=5375.0

Wapperdude

[davidgon]

It works fine! Thanks to all!