How to put file name and directory at bottom of every worksheet

P

Paul B

Pedro, if you want to put it in a cell and not in the footer this will do
it, the workbook as to be saved for this to work,
=LEFT(SUBSTITUTE(LEFT(CELL("filename"),FIND("]",CELL("filename"))),"[",""),L
EN(SUBSTITUTE(LEFT(CELL("filename"),FIND("]",CELL("filename"))),"[",""))-1)

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
M

Martin

Pedro,

You can use the footer method.

File
Page Setup
Header/Footer
Custom Footer

Either click on the icon that looks like a file with a bit of paper
sticking out or tpye into the box

&[Path]&[File]
 
Top