Know the real name and surname of user logged... (2000 sr 1)

**sal21** · 2006-10-11 14:56

I know the way to know the ID name of user logged on PC, but i want to know the real name (similar Jhon Smith) of user Name and Surname and store it in a cells...?
Or.. if existis in wich part of dir, text file or other is stored this isnfoamtion?

**HansV** · 2006-10-11 15:02

Each user can enter his or her name in the General Tab of Tools | Options. You can put this name in a cell using code like this:
<code>
Range("C37") = Application.UserName
</code>
See API: Get full name of the user currently logged in to the system for the rather complicated code to retrieve the full username.

**sal21** · 2006-10-11 15:13

Tks but no one sub get the complete username similar Jhon Smith...
Based the link you posted...?!

**FlyerMike** · 2006-10-11 15:19

Actually the fGetFullNameOfLoggedUser routine does exactly what you requested.

**HansV** · 2006-10-11 15:23

You must copy all the code from the link I posted into a module. You can then use the fGetFullNameOfLoggedUser function to get the full name of the user, if it is available.

**sal21** · 2006-10-11 16:33

Sure i have tested and FlyerMike is right, the function no take complete username, but only Id Name but i know this way to get Id Name:-(

Peraph search with a vb code in Outlook?
Because i see my real name in email inbox and if this info existis in Outlook.....!

**HansV** · 2006-10-11 18:19

Why do you need the full name? Is the login name not sufficient to identify a user?

Thread: Know the real name and surname of user logged... (2000 sr 1)

Thread Tools