Path in Footer
 

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/

Path in Footer
 

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/

Path in Footer
 

Thanks Bob, I forgot to mention that this particular Customer is al
Office 2000 - I had searched on the forums before posting including th
Tips section might be good to sticky in the tips section.

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

Path in Footer
 

John Walkenbach has an addin that may help:
http://j-walk.com/ss/excel/files/addpath.htm

"GeoffM <" wrote:

Thanks Bob, I forgot to mention that this particular Customer is all
Office 2000 - I had searched on the forums before posting including the
Tips section might be good to sticky in the tips section..

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

--

Dave Peterson