Return to Excel from Word Object

[Joyce]

I have an embedded Word object (a form that works better in Word than Excel).

I inserted a text box with the instruction to click it to activate the Word
form:

Sub WordForm()

Set obj = Sheets("sheet1").OLEObjects("Object 21")
obj.Activate

End Sub

My problem is returning the focus to the Excel worksheet when the user has
finished filling in the form. I'm sure it's pretty simple, but I can't seem
to get anything to work.

Thanks.

 

[ryguy7272]

Dim wdApp As Word.Application
'...
Set wdApp = Nothing

Some other things to try:
word.ActiveDocument.close
word.quit
SET word = nothing

Finally, there is a good example of how to dicsonnect from Word here:
http://www.erlandsendata.no/english/index.php?d=envbaolecontrolword

HTH,
Ryan---