How can I print the file name & patch in the footer?

Posted by Evelyn Tuma on June 27, 2001 2:00 PM

I'm trying to figure out how to print the path name as well as the file name within the footer of an EXCEL spreadsheet.
Example: If the file name is TEXT.XLS located in C:\EXCEL, I'd like to print: C:\EXCEL\TEXT.XLS.
Any ideas???
Thanks!

Posted by Evelyn Tuma on June 27, 2001 2:03 PM

Re: How can I print the file name & path in the footer?

Posted by Ben O. on June 27, 2001 2:16 PM

This should work:

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

Change Rightfooter to Centerfooter or Leftfooter if desired.

-Ben

Posted by Evelyn on June 27, 2001 2:52 PM

This worked for me! Thanks!!!