Obtaining the Users name either regular way or using API
:
Return to List
Application.UserName
' An alternative is to get it from the API
' This is used by GetUserName() to find the current user's name from the API
Declare Function Get_User_Name Lib "advapi32.dll" Alias _
"GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long
Function GetUserName() As String
Dim lpBuff As String * 25
Get_User_Name lpBuff, 25
GetUserName = Left(lpBuff, InStr(lpBuff, Chr(0)) - 1)
End Function
Note to Webmaster