ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Application.UserName (https://www.excelbanter.com/excel-programming/441294-application-username.html)

kalle

Application.UserName
 


Hi

I have an workbook that is used by many people and som of them hav
access to more functions.

Therefore I use Application.UserName to who is loged on.

If my real name is Carl Something I log on with abcaso but when I use
Application.UserName I get "Carl Something" but I want "abcaso"

Is it possible to get the name?

Thanks in advance

*** Sent via Developersdex http://www.developersdex.com ***

Bob Phillips[_4_]

Application.UserName
 
Use

LoggedOnUser = Environ("Username")

--

HTH

Bob

"kalle" wrote in message
...


Hi

I have an workbook that is used by many people and som of them hav
access to more functions.

Therefore I use Application.UserName to who is loged on.

If my real name is Carl Something I log on with abcaso but when I use
Application.UserName I get "Carl Something" but I want "abcaso"

Is it possible to get the name?

Thanks in advance

*** Sent via Developersdex http://www.developersdex.com ***




Mike H

Application.UserName
 
Hi,

Is this what your looking for

MsgBox Environ("UserName")


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"kalle" wrote:



Hi

I have an workbook that is used by many people and som of them hav
access to more functions.

Therefore I use Application.UserName to who is loged on.

If my real name is Carl Something I log on with abcaso but when I use
Application.UserName I get "Carl Something" but I want "abcaso"

Is it possible to get the name?

Thanks in advance

*** Sent via Developersdex http://www.developersdex.com ***
.



All times are GMT +1. The time now is 08:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com