Custom Footer using ThisWorkbook.Path?
 

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)

Custom Footer using ThisWorkbook.Path?
 

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

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"debartsa" wrote in message ...
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)

Custom Footer using ThisWorkbook.Path?
 

Thanks for your help Ron,

I'll check it out!

"Ron de Bruin" wrote in message
...
Check out this webpage
http://www.j-walk.com/ss/excel/tips/tip22.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"debartsa" wrote in message
...
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)