A
AL
Using Visual Basic in Excel, how do I obtain the user ID of the user opening
the file?
the file?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick Rothstein
Are you looking for this?...
Application.UserName
Application.UserName
C
Charlotte E
Using Visual Basic in Excel, how do I obtain the user ID of the user
opening the file?
http://www.EXCELGAARD.dk/Lib/UDFs/USERINFO/
C
Chip Pearson
Use
Environ("Username")
This returns the Windows user name.
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
Environ("Username")
This returns the Windows user name.
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
J
Jacob Skaria
Few more.
If you want to check the domain and user name use the below ...
'-----Retrieve Domain Name
' Reference Active DS Type Library Tools|Reference
Dim strAD As New ADSystemInfo
strDomainname = strAD.DomainShortName
'-----Get User Name
Set objNet = CreateObject("WScript.NetWork")
strUserName = Trim(objNet.UserName)
If this post helps click Yes
If you want to check the domain and user name use the below ...
'-----Retrieve Domain Name
' Reference Active DS Type Library Tools|Reference
Dim strAD As New ADSystemInfo
strDomainname = strAD.DomainShortName
'-----Get User Name
Set objNet = CreateObject("WScript.NetWork")
strUserName = Trim(objNet.UserName)
If this post helps click Yes