Win XP Logon Name

[Andy Ives]

Ayone know how to reference a Win XP network user name from VBA?
Any pointers to required references etc gratefully received!

Cheers

Andy

[Norman Jones]

Hi Andy.

Try:

LName = Environ("UserName")


---
Regards,
Norman



"Andy Ives" <[email protected]> wrote in message
news:[email protected]...
> Ayone know how to reference a Win XP network user name from VBA?
> Any pointers to required references etc gratefully received!
>
> Cheers
>
> Andy

[Andy Ives]

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" <[email protected]> wrote in message
> news:[email protected]...
> > Ayone know how to reference a Win XP network user name from VBA?
> > Any pointers to required references etc gratefully received!
> >
> > Cheers
> >
> > Andy
>
>
>

[Norman Jones]

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > Ayone know how to reference a Win XP network user name from VBA?
>> > Any pointers to required references etc gratefully received!
>> >
>> > Cheers
>> >
>> > Andy
>>
>>
>>