Wanted -to know how to post FILE NAME and DIRECTORY at bottom of my worksheet

  • Thread starter Thread starter Pedro
  • Start date Start date
P

Pedro

Who knows how to post the formula at the bottom of all my
excel worksheets that will give the file name and the
directory of my file???

thanks for a reply!
 
In case you wanted to put full path including sheetname in the Print-Footer
try:
You would want to also assign a button on your toolbar and put this in your
personal.xls file - works great..

Sub PathInFooter()
ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName & _
" " & ActiveSheet.Name
End Sub

HTH
 
[This followup was posted to microsoft.public.excel.misc and a copy was
sent to the cited author.]

I don't know with earlier versions, but with XL2002, the directory is an
XL-native choice in the File | Page Setup | Header and Footer tab. It
is called &[Path]. The file name, accessed through &[File], has been
available for many versions.


--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 
Back
Top