Thank you but I need further precisions.
The Word document is inbedded in a workbook
and programmatically I do not intent to act on it.
The user only opens the WB and modifies the
document if he needs and then closes the WB.
The WB is in another instance of Excel and saved
in the Before_Close sub.
Both the WB and the document have small pieces
of code mainly for design and behaviour.
So, at your idea, where should I put the code you
suggested ?
Thank you for answering.
Patrick
"Halim" a écrit dans le message de news:
...
hi,
You have to define your WORD object variable as a public variable
Public WordObj as Object
Sub Initial()
Set WordObj = createobject("word.application")
WordObj.visible = true
'do your stuff here...
End sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
WordObj.Quit
set WordObj = nothing
End Sub
--
Regards,
Halim
"Patrick Penet" wrote:
Hello Gurus,
I have a workbook which includes a Word document.
When, by VBA, the user quits this workbook, once the
Word document is edited, and returns into my app,
an instance of WINWORD is remaining active in the
tasks manager.
And more, even if the user leaves the application, this
WINWORD.EXE remains active and raises a problem
at the closing of Windows.
Any ideas, APIs, tips or tricks well accepted.
Many thanks.
Patrick