On Exit

[daybase]

Is it possible to apply an On Exit event to Microsoft word document?

 

[TonyJollans]

Hi daybase,

You need an AutoClose macro. Just name a macro AutoClose and it should run - scope will depend on where you put it. If it's in a document it should only run when that document is closed. if it's in your Normal template it will run when most any document is closed.

Enjoy,
Tony

 

[daybase]

Thanks for that - is that a macro in word? How about if I want to trigger Access VBA code when I close or exit a word document?

 

[TonyJollans]

Hi daybase,

Yes, that's a macro in Word. From it you can do (more or less) what you want. If you add the following to the ThisDocument code module (under Microsoft Word Objects in your document) it will run a VBA routine in an Access Database when you close your document:

Sub AutoClose()

Dim appAccess As Access.Application

Set appAccess = CreateObject("Access.Application")

With appAccess
    .OpenCurrentDatabase "

D:\My Documents\db3.mdb

"
    .Run "

myPublicSubInAccessDatabase

"
    .CloseCurrentDatabase
    .Quit
End With

Set appAccess = Nothing

End Sub

(changing my names for yours, of course)

Enjoy,
Tony