'Declarations - Public or Private
' Form Level, Module Level
Public Declare Function GetUserName Lib "advapi32.dll" Alias _
"GetUserNameA" (ByVal lpBuffer As String, _
nSize As Long) As Long
Public Function GetWindowsLoginUserID() As String
Dim rtn As Long
Dim sBuffer As String
Dim lSize As Long
Dim lngInstr As Long
sBuffer = String$(260, Chr$(0))
lSize = Len(sBuffer)
rtn = GetUserName(sBuffer, lSize)
If rtn <> 0 Then
sBuffer = Left$(sBuffer, lSize)
lngInstr = InStr(sBuffer, Chr$(0))
If lngInstr > 0 Then
sBuffer = _
Left$(sBuffer, lngInstr - 1)
End If
GetWindowsLoginUserID = sBuffer
Else
GetWindowsLoginUserID = ""
End If
End Function
Compare Code (Text)
Generate Sort in VB or VBScript