I am new to event programming and am having problems figuring out how
to create a program that will run another program whenever the save or
saveas command is used. Does anyone know of sample code that would
point me in the right direction?
If you want to constantly monitor for events, you should make an
add-in. Keeping a macro on to monitor events eats up a lot of
processor bandwidth and is not as reliable.
Get familiar with the "Withevents" option when defining object
variables. You need to specify this, or you simply will have no access
to an object's event triggers.
I have a VB6 template for creating addins from macros. It is on my
website somewhere, . (I can't remember
the exact link, I am in China at the moment and can not get access to
my own site over the "Great Firewall of China".)