how to print file address of the file on page?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want the file address to show on the bottom of my printed page. like
c:/myfiles
 
File...page setup...header footer tab...custom footer...click the icon that
looks like a little folder and it should insert the path and file
 
If you have Excel 2002 or newer this path and filename is available under
View>Header and Footer.

Sometimes in the built-ins but if not, under Custom you have Icons to click on
to customize the footer.

If an older version of Excel you will need VBA code similar to this.

Sub PathInFooter()
ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName
End Sub

Note: the workbook must have been saved once in order to have a path.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word want to batch print some specific pages in multiple word files 0
PowerPoint Printing PPT to PDF without losing quality 1
Print contents of sub folders 1
How can we convert OST to PDF file format? 1
Linking certain cells from Multiple files in a folder onto a summa 1
Print to file 5
Excel row height v. printed page 4
Picture Links printing problem - Help! 1

Back
Top