User's login or LanID

[Jornyboy]

Eh oh all!

What command could I use in Excel to capture the User's login or LanID?

I know this is possible but i Cant seem to be able to find it in the help for VBA

Kind Regards

John.

 

[masim]

for user name

Sub Button2_Click()
Dim strUserName As String
strUserName = Environ("username")
MsgBox (strUserName)
End Sub

for computer name

Sub Button1_Click()
Dim strUserName As String
strUserName = Environ("computername")
MsgBox (strUserName)
End Sub

Hope that helps
Regards
Asim