Application.UserName retrieves wrong username / where does it get its data?

[Michiel via OfficeKB.com]

Hi,

Does anyone know where Application.UserName retrieves its data?

When I entered the firm my Windows UserID was ABC
Later they changed it to XYZ

Everywhere in Windows I can see my user-ID is XYZ (eg in documents and
settings and of course when logging on/off)

However, when I run "?Application.UserName" in the immediate window, VBA
retrieves my old user-ID ABC instead of XYZ.

Also, when I create a new file and lok at properties. The user-ID ABC is
shown.

Where should I look to fix this?

Thanks!

 

[Shauna Kelly]

Hi Michiel

Application.UserName reports whatever you type at Tools > Options > User
Information.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word

 

[Jay Freedman]

Also, if you need to get the network username in VBA code, see
http://www.word.mvps.org/FAQs/MacrosVBA/GetCurUserName.htm.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Michiel via OfficeKB.com]

Shauna and Jay,

It worked (both ways)!
Thank you so much both for help!!

Michiel.