Function that gives Windows current user name?

[Petu]

I need to know current Windows user name and update it to Excel sheet by
function?

 

[Harald Staff]

Hi

This needs a little VBA. In Win NT / Win 2000 / Win XP it's simply

Function CurrentUser() As String
CurrentUser = Environ("username")
End Function

Win 9x requires some windows programming. Post back if that's needed.

HTH. Best wishes Harald

 

[Frank Kabel]

Hi
in VBA use:
msgbox environ("username")