Login Name - VBA

[Guest]

Hello,

I am developing an user interface using VBA in which i want to get the
Username using VBA and not inputted by the user manually..

To get this, i thought of using Application.UserName property, but was told
that it would only give the name to whom the Excel is licensed..i can't bet
on it...so what i thought was to get the Login Name used to login to the
System (Windows XP)..

Whoever logs into tthe system and use this program, that name would be
automatically used!!!

Could anybody help me in getting the Login Name using VBA?

Cheers

Sri

 

[Bob Phillips]

Sri,

You have been told correctly. Use

sUser = Environ("UserName")

--

HTH

RP
(remove nothere from the email address if mailing direct)