| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Win XP Logon Name
Ayone know how to reference a Win XP network user name from VBA?
Any pointers to required references etc gratefully received! Cheers Andy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Win XP Logon Name
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Win XP Logon Name
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Logon | New Users to Excel | |||
| logon | Excel Discussion (Misc queries) | |||
| Logon Screen | Excel Worksheet Functions | |||
| Logon information | Excel Programming | |||
| NT Domain Logon | Excel Programming | |||
![Andy Ives[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
