Results 1 to 7 of 7
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

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

    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.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

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

  4. #4
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Cincinnati, Ohio, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    Actually the fGetFullNameOfLoggedUser routine does exactly what you requested.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

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

    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.

  6. #6
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Know the real name and surname of user logged.

    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.....!

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Know the real name and surname of user logged.

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •