Inserting the full file path in headers and footers in Excel : A look

Excel 97 doesn't offer you the option of displaying the full file path in worksheet headers and footers. With a little basic VBA editing, you can add this functionality to users' systems.
1. Go to Tools | Macro | Visual Basic Editor.
2. Go to the View menu and select Code.
3. Type the following:
Sub PathFooter()
ActiveSheet.PageSetup
LeftFooter=ActiveWorkbook
FullName
End sub
4. Go to File | Close.
Return to your workbook and save the file. You can now run your macro by navigating to Macros and choosing the one named PathFooter.


Comments

No responses found. Be the first to comment...


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: