Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Temporarily Unhiding | Excel Discussion (Misc queries) | |||
Temporarily Disable Autocorrect | Excel Discussion (Misc queries) | |||
Temporarily turning off the keyboard? | Excel Programming | |||
Excel 2000/XP script to Excel97 script | Excel Programming | |||
Temporarily delete ALL CommandBars? | Excel Programming |