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

[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!

 

[JON JON]

=CELL("Filename",A1).

file must be saved for the first time.

Regards,

Jon-jon

 

[JMay]

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

 

[Tushar Mehta]

[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