Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    File Info (XL 2002)

    Does anyone know an easy way to incorporate into my worksheet, some of the File Info, such as the Network Id of the person who last saved the file?

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

    Re: File Info (XL 2002)

    Excel stores the name of the last user who edited the workbook as specified in the General tab of Tools | Options, not the network user name. You could use the BeforeSave event of the workbook to store the network username in a cell in the worksheet. See <post#=567,427>post 567,427</post#>.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: File Info (XL 2002)

    The line:
    sUserName = environ("Username")

    can be used in a VB routine (subroutine or macro) to put it into a variable. What other info are you after and what do you want to do with it?

    Steve

  4. #4
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: File Info (XL 2002)

    Thanks to both Hans and Steve. Will investigate both responses

Posting Permissions

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