macros
 

How do I print the file path on the bottom of a document?

macros
 

Barbara,

This is built into xl2002, &[Path]&[File], but earlier versions required a
macro .

This code, placed in the ThisWorkbook code module, automatically sets the
full name when printing.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftFooter = ThisWorkbook.FullName
End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Barbara" wrote in message
...
How do I print the file path on the bottom of a document?