Path in Footer

  • Thread starter Thread starter GeoffM
  • Start date Start date
G

GeoffM

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
 
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)
 
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.
 
Back
Top