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.

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/charle...2/10/3574.aspx for
details.

"Dave VB logic for excel" wrote:

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.