Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Path in page footer | Excel Discussion (Misc queries) | |||
Path and File Name to Footer | Excel Discussion (Misc queries) | |||
Entering Path Name in Footer | Excel Worksheet Functions | |||
Full path in custom footer. How? | Excel Programming | |||
Full path in custom footer. How? | Excel Programming |