Results 1 to 3 of 3

Thread: How to see full file path in Microsoft Excel 2003

  1. #1
    Join Date
    Jan 2012
    Posts
    23

    How to see full file path in Microsoft Excel 2003

    Excel 2003 has an option to display a Web toolbar that would show the entire file path and name of the active file. I cannot find an equivalent function in Excel 2007, can someone tell me how to accomplish that? The same problem exists with Word 2007--I was able to get a macro that will display the full file path in the doc title bar once the macro is added to the Normal template. A similar solution for Excel would work, but I would prefer to find an option that would automatically display the full file path as the Web toolbar did.

  2. #2
    Join Date
    Jul 2011
    Posts
    640

    Re: How to see full file path in Microsoft Excel 2003

    You could add the Document Location control from the All Commands group to the QAT as described here.

    What happened to the Web toolbar

    Insert the current Excel file name, path, or worksheet in a cell

  3. #3
    Join Date
    Jun 2011
    Posts
    635

    Re: How to see full file path in Microsoft Excel 2003

    This was the method that I had used a very long time before and hope that this works. Try to add insert the following formula in a cell: = INFO ("directory"). This might give you the full path on the current sheet. Or In the box "layout" tab select the> top and footer> footer personalized and you enter the desired data by clicking on the appropriate icons. If you want to re-sheet information in all of your workbook, select the earlier stages.

Similar Threads

  1. Replies: 6
    Last Post: 17-02-2012, 01:18 PM
  2. Modify Backup Copy path of Microsoft Excel
    By Kumar esan in forum MS Office Support
    Replies: 6
    Last Post: 25-01-2012, 06:15 PM
  3. Replies: 2
    Last Post: 25-01-2012, 06:10 PM
  4. Replies: 4
    Last Post: 13-12-2010, 05:34 PM
  5. How to export a Project 2003 file into Excel 2003
    By destinyswarrior in forum Windows Software
    Replies: 3
    Last Post: 21-03-2009, 05:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,710,814.40811 seconds with 17 queries