Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Nov 2009
    Location
    The Great NW
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Can anyone help with me with automatically inserting the filename and path into a cell in the spreadsheet? Can't seem to find it in Excel 2007.

    Thanks,
    blackjeep22

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

    =CELL("filename")


  3. #3
    New Lounger
    Join Date
    Nov 2009
    Location
    The Great NW
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by HansV View Post
    Try the formula

    =CELL("filename")
    PERFECT! Thank you!

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Just out of interest, why do you want it in a cell?
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    New Lounger
    Join Date
    Nov 2009
    Location
    The Great NW
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by rory View Post
    Just out of interest, why do you want it in a cell?
    Many times when I go through the printed copies of my electronic documents... that perhaps I want to modify... I can't find them. I have 2 computers.
    To assist with my deteriorating memory... I have found it helpful to have the location automatically shown on the printed document. In Word... (at least the version prior to 2007) this can be done through pulldowns. I looked all over for a similar way to do this in Excel.... but after receiving the tip from "slinky"... remembered that it was done with a formula... which I also forgot. It's hell getting old.
    I just looked around in Word 2007 and don't see the simple pulldown for this there either.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    If you want to see the path and filename in printouts of a worksheet, you can add them to the page header or footer; they are among the "Header & Footer Elements". See Microsoft Excel : Headers and Footers in Excel 2007.

    For Word, see How to Add the Filename and Path to a Word 2007 Document.


  7. #7
    New Lounger
    Join Date
    Nov 2009
    Location
    The Great NW
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by HansV View Post
    If you want to see the path and filename in printouts of a worksheet, you can add them to the page header or footer; they are among the "Header & Footer Elements". See Microsoft Excel : Headers and Footers in Excel 2007.

    For Word, see How to Add the Filename and Path to a Word 2007 Document.
    WOW! Thanks for the links. I will certainly save them.... I do have to agree with "Mame" on that link though:
    "This is a classic example of ďif it ainít broke, donít fix itĒ. It was simple before and now itís convoluted with LOTS of steps. I just donít get it why take things from step to difficult?"

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The ribbon was supposed to make things easier to find, and that may be true for some, but many actions take more mouse clicks in Office 2007 than in earlier versions.


Posting Permissions

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