Geoff,

2nd time today.

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


If you just want the path, change FullName to Parth.

--

HTH

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

"GeoffM " wrote in message
...
I once used this a while back but can not find referance to it anymore -


in the footer the dockument path would be displayed/printed helping
users find the document in the network share I believe it was a VBS
script apply to the Excel template


---
Message posted from http://www.ExcelForum.com/