Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run macro for all documents
Hi,
I have to add a custom footer to every excel document based on an enviromental variable. This isn't a problem I've got the vb/vba code to do this. My problem is that I'm not really sure where to put it. No matter what the document is or what template it is based on I need to run this code. I was wondering if I should put it in Excel10.xlb or is there somewhere else that is always checked for code? If I put it in Excel10.xlb will I also need to put it in any existing templates that are used? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run macro for all documents
Blackstar wrote: Hi, I have to add a custom footer to every excel document based on an enviromental variable. This isn't a problem I've got the vb/vba code to do this. My problem is that I'm not really sure where to put it. No matter what the document is or what template it is based on I need to run this code. I was wondering if I should put it in Excel10.xlb or is there somewhere else that is always checked for code? If I put it in Excel10.xlb will I also need to put it in any existing templates that are used? Thanks Edit the code must be run on save so it has to be in the ThisWorkbook (Wookbook_BeforeSave) Method. So unfortunetly I don't beleive that using personal.xls will work as this only seems to work for macros rather than vba. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run macro for all documents
If you need this code to run when any file is printed/opened/saved, you will
to look into Application Level events. http://www.cpearson.com/excel/AppEvent.htm NickHK "Blackstar" wrote in message oups.com... Hi, I have to add a custom footer to every excel document based on an enviromental variable. This isn't a problem I've got the vb/vba code to do this. My problem is that I'm not really sure where to put it. No matter what the document is or what template it is based on I need to run this code. I was wondering if I should put it in Excel10.xlb or is there somewhere else that is always checked for code? If I put it in Excel10.xlb will I also need to put it in any existing templates that are used? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run macro for all documents
App Level events...genius. Many thanks
NickHK wrote: If you need this code to run when any file is printed/opened/saved, you will to look into Application Level events. http://www.cpearson.com/excel/AppEvent.htm NickHK "Blackstar" wrote in message oups.com... Hi, I have to add a custom footer to every excel document based on an enviromental variable. This isn't a problem I've got the vb/vba code to do this. My problem is that I'm not really sure where to put it. No matter what the document is or what template it is based on I need to run this code. I was wondering if I should put it in Excel10.xlb or is there somewhere else that is always checked for code? If I put it in Excel10.xlb will I also need to put it in any existing templates that are used? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Excel Macro to Print Word Documents | Excel Programming | |||
Menu linked to macro showing up in all documents | Excel Programming | |||
Creating Word Documents with an Excel Macro | Excel Programming | |||
Macro assignations follow new documents | Excel Programming | |||
listing which documents were changed by macro | Excel Programming |