Discussion Locked

Excel 2000

0 helpful

5 replies

by jetbonami Aug 27, 2002 last reply Sep 4, 2002

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How do I get the path of the Excel 2000 document I'm opening to appear on the document both on screen and hard copy?

5 replies

by dklippert Aug 27, 2002

To show the path on the title bar, you could use:

Sub Auto_Open()
ActiveWindow.Caption = ActiveWorkbook.FullName
End Sub

To show the path in a cell the formula is

=CELL("filename",A1)

by jetbonami Aug 27, 2002

We are trying to have the file path show in the footer of the printed Excel worksheet (just like pagination). I seem to remember a simple menu item, button or option (off View - Header/Footer maybe) that allows you to do this without using a formulaor code. Is this familiar?

by dklippert Aug 27, 2002

Excel 2002 has &[Path], but in earlier versions you need to either type it in or use a macro like:
Sub PathInFooter()
ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.FullName
End Sub

You can find furter discussion at:

www.mvps.org/dmcritchie/excel/pathname.htm

by jetbonami Sep 4, 2002

Thanks DK, the website looks promising--

by jetbonami Sep 4, 2002

This question was closed by the author

This discussion is closed to new replies.

5 replies

Trending Software posts

Icons, favicons and merch graphics on Squarespace: my workflow for getting

Network Printer Works for Everyone Except Me

Can I Print Emails Directly from a PST File

Is There any Reverse Video Search Tool

Useful software Tip or Shortcut