Prev: Cdbl and Cstr with a "Type Mismatch" Error
Next: Multipage userform
From: kalle on 3 Apr 2010 04:38


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 ***
From: Bob Phillips on 3 Apr 2010 05:52
Use

LoggedOnUser = Environ("Username")

--

HTH

Bob

"kalle" <kalle(a)yahoo.com> wrote in message
news:OwbFXkw0KHA.6104(a)TK2MSFTNGP06.phx.gbl...
>
>
> 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 ***


From: Mike H on 3 Apr 2010 05:55
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 ***
> .
>
 | 
Pages: 1
Prev: Cdbl and Cstr with a "Type Mismatch" Error
Next: Multipage userform