Getting the computer user name

[Jaymin]

Hope someone can help me, i want to get access to tell me who has loged onto the computer, i know in excel there is a code

GetXLUserName

this gives you there login name,

Peter

 

[jdraw]

You may try Environ("USERNAME")

 

[Galaxiom]

The weakness with the username environment variable is that it can be changed by the user.

This is more reliable:
CreateObject("wscript.network").UserName

Best encapsulated in a function so the wscript object is destroyed after returning the value.

 

[Jaymin]

Jdraw and Galaxiom,
Thank you for your replies.
Galaxiom can you show me how to program what you have suggested

encapsulated in a function so the wscript object is destroyed after returning the value

Peter

 

[Galaxiom]

If you want to get to it from the whole project (including queries) put it in a Standard Module.

Public Function fUserName()
 
   fUserName = CreateObject("wscript.network").UserName
 
End Function

Use it like this in subs:
somevariable = fUserName

 

[Jaymin]

Galaxiom,
Thank you for your help and time, also a quick responce.
Peter