Changing Office User Name?

[Rob B.]

All our systems come pre-configured with Office 2003. In Word, Excel, and
Powerpoint, the user name option is set to "ABC User."

Word: Tools -> Options -> User Information tab -> Name field
Excel: Tools -> Options -> General tab -> User name field
PowerPoint: Tools -> Options -> General tab -> Name field

When some tries to open an Office file (on a network file share) that is
already open, they receive a dialog that tells them "ABC User" has the file
open. Obviously, that's not useful information.

Is there a way to get these Office products to automatically populate the
User/Name field with the currently logged on user, so that when a 2nd person
tries to open the file, they get the user's name rather than, "ABC User?"


Rob B.

 

[Milly Staples [MVP - Outlook]]

Not without changing it manually. Use Word for the change.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Rob B. asked:

| All our systems come pre-configured with Office 2003. In Word,
| Excel, and Powerpoint, the user name option is set to "ABC User."
|
| Word: Tools -> Options -> User Information tab -> Name field
| Excel: Tools -> Options -> General tab -> User name field
| PowerPoint: Tools -> Options -> General tab -> Name field
|
| When some tries to open an Office file (on a network file share) that
| is already open, they receive a dialog that tells them "ABC User" has
| the file open. Obviously, that's not useful information.
|
| Is there a way to get these Office products to automatically populate
| the User/Name field with the currently logged on user, so that when a
| 2nd person tries to open the file, they get the user's name rather
| than, "ABC User?"
|
|
| Rob B.

 

[Harlan Grove]

Not without changing it manually. Use Word for the change.

....

It could be automated, even using VBA making use of WSH objects. This
is just the wrong newsgroup in which to try to get that sort of
answer.

FWIW, Office 2003 company name, user initials and name are stored as
binary unicode strings in the following registry key.

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\UserInfo

If users have any e-mail accounts, it's a virtual certainty their true
names are stored somewhere else in the registry. Not that difficult to
fetch the user's name from an e-mail software key, convert it into
ASCII representations of hexadecimal 2-byte character codes with
terminating null (e.g., "test" becomes "74 00 65 00 73 00 74 00 00
00"), and write that to the version-appropriate Office UserInfo key.