how to print file address of the file on page?
If you have Excel 2002 or newer this path and filename is available under
ViewHeader 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
On Fri, 1 Sep 2006 11:07:02 -0700, Ginette
wrote:
I want the file address to show on the bottom of my printed page. like
c:/myfiles
|