Getting the currently logged-in windows user

You could also do this:

Set WshNetwork = CreateObject("WScript.Network")Print WshNetwork.UserName

It also has a UserDomain property and a bunch of other things:

vba ms-access winapi

You could also use Environ$ but the method specified by the question is better. Users/Applications can change the environment variables.

vba ms-access winapi

I generally use an environ from within VBA as in the following. I haven't had the problems that Ken mentions as possibilities.

Function UserNameWindows() As String    UserNameWindows = VBA.Environ("USERNAME") & "@" & VBA.Environ("USERDOMAIN")End Function

CodeHunter