Network Username

[Adrian D. Bailey]

Excel 2000 / Windows 2000.
Connected to an MS Active Directory network.

I need to find the login name of the user running the Excel VBA macro.
This is NOT the same as "username" returned by VBA.
(In a cmd window the value I want is returned by the command line "echo
%username%" )

--
Adrian D.Bailey, Information and Systems Manager, Dept.Human Sciences
Loughborough University, Loughborough Leics, LE11 3TU, UK.
(e-mail address removed) Tel: 01509 223007 Fax: 01509 223940

Community Warden, Storer and Burleigh Areas. Out-of-hours Tel: 01509 563263
--

 

[Bob Phillips]

Environ("UserName")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Zack Barresse]

Hello,

Here is a little more info on it ..

http://vbaexpress.com/kb/getarticle.php?kb_id=234

HTH