Hugo,
In a class module:
Dim WithEvents MyWord As Word.Application
Private Sub MyWord_Quit()
MsgBox "Excel again"
End Sub
Your original sub would need to end before then original MsgBox.
But you will then be notified when Word quits.
NickHK
"H.A. de Wilde"
wrote in message
news:H.A.de.Wilde.27a3bm_1146738301.6109@excelforu m-nospam.com...
L.S.,
Within Excel I am running a script that opens a new Word-document.
I like to stop the script temporarily untill the Word-session is
closed.
Example:
Set objWord = CreateObject("Word.Application")
objWord.Visible = True
Set objDoc = objWord.documents.Add
Msgbox ("Excel again")
The message should appear after closing the Word-session.
Possible?
With kind regards,
Hugo
--
H.A. de Wilde
------------------------------------------------------------------------
H.A. de Wilde's Profile:
http://www.excelforum.com/member.php...o&userid=30679
View this thread: http://www.excelforum.com/showthread...hreadid=538800