file pathway as footer

[gabrika]

Hi, Does anyone know if it's possible to add the file
filename and path automatically in an Excel Workbook as a
header or footer? I know you can do this in Word.

Thanks!

 

[JE McGimpsey]

See

http://www.mcgimpsey.com/macoffice/excel/fullnameinfooter.html

for instructions on a per workbook basis, or for all workbooks:

http://www.mcgimpsey.com/macoffice/excel/fullnameinfooter2.html

 

[CLR]

I use XL2k and you can put the filename in the footer by doing File > Page
setup > Header/footer tab > Custom Footer > then select a section and click
on the X icon, (the second from the right)..............to insert the path,
you need code.......

Vaya con Dios,
Chuck, CABGx3