Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
environ username vs. application username
i am using the following codes to obtain a user name:
Function ThisUser() ThisUser = Environ("UserName") End Function Function MyName() MyName = Application.UserName End Function both work, ThisUser returns my login id (ex. jat) and MyName returns my name that i have entered in Excel's Personalization area (ex. jat man) What i would like is to get the MyName to be retrieved from my actual profile. When i go to Start, my name shows at the top (first last name), and that is set up when my profile is created. How do i retrieve this in a macro? jat |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Username | Excel Programming | |||
Environ("username") | Excel Programming | |||
Application.UserName Question | Excel Discussion (Misc queries) | |||
Including Environ Username in Cell | Excel Worksheet Functions | |||
application.username | Excel Programming |