View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Win XP Logon Name

Hi Andy,

I've just found Application.Username in the Excel Object Model and that
seems to work too


That returns the name inserted in:

Tools | Options | General | User Name.

This is the Excel user name and can freely be changed.

Environ("UserName") returns the Windows logon name.

---
Regards,
Norman



"Andy Ives" wrote in message
...
Thanks norman - works a treat.
I've just found Application.Username in the Excel Object Model and that
seems to work too

Cheers

Andy

"Norman Jones" wrote:

Hi Andy.

Try:

LName = Environ("UserName")


---
Regards,
Norman



"Andy Ives" wrote in message
...
Ayone know how to reference a Win XP network user name from VBA?
Any pointers to required references etc gratefully received!

Cheers

Andy