| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Add Foorter with full filename in Excel
Hi All
I am trying to add the full path name of the file as a footer to every excel file that is created new or opened in Excel. I am quite certain this can be done through VBA but not sure how. Can someone please help? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically Add Foorter with full filename in Excel
Hi
depending on your Excel version you could create a new template and save this as book.xlt in your XLStart folder -----Original Message----- Hi All I am trying to add the full path name of the file as a footer to every excel file that is created new or opened in Excel. I am quite certain this can be done through VBA but not sure how. Can someone please help? Thanks . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically Add Foorter with full filename in Excel
I am using Office 2003 and placed the file called book.xlt in the XLstartup
folder but it simply opens up the book.xlt together with a new workbook. What I really need is an automactic way of including the footer on everyfile that is opened or created from now on Any more suggestions "Frank Kabel" wrote in message ... Hi depending on your Excel version you could create a new template and save this as book.xlt in your XLStart folder -----Original Message----- Hi All I am trying to add the full path name of the file as a footer to every excel file that is created new or opened in Excel. I am quite certain this can be done through VBA but not sure how. Can someone please help? Thanks . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically Add Foorter with full filename in Excel
Also look at Chip Pearson's page on application level events
http://www.cpearson.com/excel/appevent.htm -- Regards, Tom Ogilvy "JP SIngh" wrote in message ... Hi All I am trying to add the full path name of the file as a footer to every excel file that is created new or opened in Excel. I am quite certain this can be done through VBA but not sure how. Can someone please help? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent Excel putting full filename in external links on update | Excel Discussion (Misc queries) | |||
| Filename in footer automatically in new workbook. | Excel Discussion (Misc queries) | |||
| Trim path from full filename | Excel Programming | |||
| Automatically saving an Excel spreadsheet with today's date in the filename | Excel Programming | |||
| Function to return filepath given full filename | Excel Programming | |||
Linear Mode
