Closing word

[Tammy]

I need to execute a function upon closing a word document
(based on a template). I haven't done this in Word
before - any suggestions? I have originated this
document from Access and need to close it out before
focus goes back to Access.

Thanks!

 

[Jay Freedman]

Hi, Tammy,

Depending on what you need to do, one of these articles should help:

Run a macro automatically when Word starts or quits
http://www.mvps.org/word/FAQs/MacrosVBA/ApplicationEvents.htm

Run a macro automatically when a document is created, opened or closed
http://www.mvps.org/word/FAQs/MacrosVBA/DocumentEvents.htm

How to create global event procedures similar to AutoOpen, AutoNew and
AutoClose, without using Normal.dot
http://www.mvps.org/word/FAQs/MacrosVBA/PseudoAutoMacros.htm