What is the fucntion or formula to capture username into excel she

[Dave VB logic for excel]

Hello,

Im currently workin gin excel sheet. i want the sheet to capture the
username from system or licence details whener the user open the sheet.
So what is the function i can use or vb formula i can to enable the system
to capture the details.

Thanks in advanced.

 

[Sheeloo]

Following is from Charles Maxon's blog;

Function UserNameWindows() As String
UserName = Environ("USERNAME")
End Function

It worked for me in Excel 2007.


See http://blogs.officezealot.com/charles/archive/2004/12/10/3574.aspx for
details.