Network Username

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adrian D. Bailey - 20 Jan 2006 17:03 GMT

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.
A.D.Bailey@lboro.ac.uk Tel: 01509 223007 Fax: 01509 223940

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

Reply to this Message

Bob Phillips - 20 Jan 2006 17:09 GMT

Environ("UserName")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

> Excel 2000 / Windows 2000.
> Connected to an MS Active Directory network.
[quoted text clipped - 11 lines]
> Community Warden, Storer and Burleigh Areas. Out-of-hours Tel: 01509 563263
> --

Reply to this Message

Zack Barresse - 20 Jan 2006 17:49 GMT

Hello,

Here is a little more info on it ..

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

HTH

Signature

Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.

> Excel 2000 / Windows 2000.
> Connected to an MS Active Directory network.
[quoted text clipped - 12 lines]
> 563263
> --

Reply to this Message