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

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.

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

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