File path in XL footer

  • Thread starter Thread starter Swizzle
  • Start date Start date
S

Swizzle

Does anyone know how to add the path of the XL file to the
footer? I am using XL 2000. I tried using the Visual
Basic, but know nothing about how the formatting should be.
 
Swizzle, try this, you could also use it in a before print macro

Sub footer()
ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.FullName
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Back
Top