Custom Footer using ThisWorkbook.Path?

[debartsa]

Hi Everybody,

I'm looking to create a custom Footer for an existing Excel 97 document.
Within the custom footer I'd like to dynamically include the application
path and file name of the excel document.

Would this be done using calls to the Excel Object model namely the
following command:

ThisWorkbook.Path

If so, exactly what would be the syntax used to embed the code within the
custom footer frame?

Thanks for any help!
Sam
(Newbie)

 

[Ron de Bruin]

Check out this webpage
http://www.j-walk.com/ss/excel/tips/tip22.htm

 

[debartsa]

Thanks for your help Ron,

I'll check it out!

Check out this webpage
http://www.j-walk.com/ss/excel/tips/tip22.htm