• Creator
  • #2146063

    Excel VBA returning User details


    by david_j_will ·

    I am trying to create an excel spreadsheet that looks using VBA code at the User’s details logged into the network via the pc and returns the information to a cell on the spreadsheet.

    I have looked at the environ function and can use that to display username etc however my organisation allocates employees a numberical login e.g. 123456 where I want the actual user’s name e.g. Williams, David.

    when logged into the computer I can see the users name I want on the top of the start menu. This appears to be retrieved from MS exchange email account without the word mailbox – Williams, David. Can someone tell me how to use this reference to display in Excel the same way it does on the start menu.

All Answers

Viewing 0 reply threads