Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Location
    Manchester
    Posts
    21

    Unanswered: Network User ID functions

    Is there any way I can get excel to place the logged on PC name in a cell on a sheet.
    At present I'm using the current user commmand but this only gives a name if the user has added an Id to there option parameters.

    Cheers

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    Take your pick

    Code:
    Sub Test()
        Range("A1").Value = Application.UserName
        Range("A2").Value = Environ("Username")
        Range("A3").Value = Environ("COMPUTERNAME")
        
    End Sub

Posting Permissions

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