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

Salut Patrick

This may be a stupid idea, but anyway: you may have Outlook already running
Word (defined as mail editor in Outlook options)?

HTH
Cordially
Pascal (not to be considered as an Excel guru!)

"Patrick Penet" <(E-Mail Removed)> a écrit dans le message de
news: 46d6a051$0$21142$(E-Mail Removed)...
> 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
>
>
>

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

>you may have Outlook already running Word (defined as mail editor in Outlook options ?

No, this is not the case.
Merci, anyway.
;-)
Patrick

"papou" <cpapoupasbon@çanonpluslaposte.net> a écrit dans le message de news: eEw1%(E-Mail Removed)...
> Salut Patrick
>
> This may be a stupid idea, but anyway: you may have Outlook already running Word (defined as mail editor in Outlook options)?
>
> HTH
> Cordially
> Pascal (not to be considered as an Excel guru!)
>
> "Patrick Penet" <(E-Mail Removed)> a écrit dans le message de news:
> 46d6a051$0$21142$(E-Mail Removed)...
>> 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
>>
>>
>>
>
>

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" <(E-Mail Removed)> a écrit dans le message de news: 0412F897-F66A-41D7-8310-(E-Mail Removed)...
> 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

Place this code below in a standard module:
code below will open word better if you run 'Initial' once at first.
Public WordObj as Object
Sub Initial()
Set WordObj = createobject("word.application")
WordObj.visible = true
'do your stuff here...
End sub

Then place code below in ThisWorkbook module:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
WordObj.Quit
set WordObj = nothing
End Sub

--
Regards,

Halim



"Patrick Penet" wrote:

> 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" <(E-Mail Removed)> a écrit dans le message de news: 0412F897-F66A-41D7-8310-(E-Mail Removed)...
> > 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
>
>
>

Sorry Halim it does not work.
Actually this code is opening a new instance of Word
but not the one wich is embedded in XL.

The problem is : if the user needs to modify the
text of the embedded Word, he first select the
Word object (right click) and then double click
on it.

This will open an instance of Word "inside" Excel.

This is this instance that would not terminate when
closing the workbook.

Thanks anyhow.

Patrick

"Halim" <(E-Mail Removed)> a écrit dans le message de news: 2220FAFA-27E2-454F-A0F0-(E-Mail Removed)...
> Place this code below in a standard module:
> code below will open word better if you run 'Initial' once at first.
> Public WordObj as Object
> Sub Initial()
> Set WordObj = createobject("word.application")
> WordObj.visible = true
> 'do your stuff here...
> End sub
>
> Then place code below in ThisWorkbook module:
> Private Sub Workbook_BeforeClose(Cancel As Boolean)
> WordObj.Quit
> set WordObj = nothing
> End Sub
>
> --
> Regards,
>
> Halim
>
>
>
> "Patrick Penet" wrote:
>
>> 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" <(E-Mail Removed)> a écrit dans le message de news: 0412F897-F66A-41D7-8310-(E-Mail Removed)...
>> > 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
>>
>>
>>

Salut Patrick
Have a look at this and see if it helps:
http://www.vbfrance.com/codes/LISTER...-API_4422.aspx

HTH
Cordially
Pascal

"Patrick Penet" <(E-Mail Removed)> a écrit dans le message de
news: 46d931c3$0$21147$(E-Mail Removed)...
> Sorry Halim it does not work.
> Actually this code is opening a new instance of Word
> but not the one wich is embedded in XL.
>
> The problem is : if the user needs to modify the
> text of the embedded Word, he first select the
> Word object (right click) and then double click
> on it.
>
> This will open an instance of Word "inside" Excel.
>
> This is this instance that would not terminate when
> closing the workbook.
>
> Thanks anyhow.
>
> Patrick
>
> "Halim" <(E-Mail Removed)> a écrit dans le message de news:
> 2220FAFA-27E2-454F-A0F0-(E-Mail Removed)...
>> Place this code below in a standard module:
>> code below will open word better if you run 'Initial' once at first.
>> Public WordObj as Object
>> Sub Initial()
>> Set WordObj = createobject("word.application")
>> WordObj.visible = true
>> 'do your stuff here...
>> End sub
>>
>> Then place code below in ThisWorkbook module:
>> Private Sub Workbook_BeforeClose(Cancel As Boolean)
>> WordObj.Quit
>> set WordObj = nothing
>> End Sub
>>
>> --
>> Regards,
>>
>> Halim
>>
>>
>>
>> "Patrick Penet" wrote:
>>
>>> 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" <(E-Mail Removed)> a écrit dans le message de
>>> news: 0412F897-F66A-41D7-8310-(E-Mail Removed)...
>>> > 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
>>>
>>>
>>>
>
>

Merci Papou, ça marche !
@ +
Patrick


"papou" <cpapoupasbon@çanonpluslaposte.net> a écrit dans le message de news: (E-Mail Removed)...
> Salut Patrick
> Have a look at this and see if it helps:
> http://www.vbfrance.com/codes/LISTER...-API_4422.aspx
>
> HTH
> Cordially
> Pascal
>
> "Patrick Penet" <(E-Mail Removed)> a écrit dans le message de news:
> 46d931c3$0$21147$(E-Mail Removed)...
>> Sorry Halim it does not work.
>> Actually this code is opening a new instance of Word
>> but not the one wich is embedded in XL.
>>
>> The problem is : if the user needs to modify the
>> text of the embedded Word, he first select the
>> Word object (right click) and then double click
>> on it.
>>
>> This will open an instance of Word "inside" Excel.
>>
>> This is this instance that would not terminate when
>> closing the workbook.
>>
>> Thanks anyhow.
>>
>> Patrick
>>
>> "Halim" <(E-Mail Removed)> a écrit dans le message de news: 2220FAFA-27E2-454F-A0F0-(E-Mail Removed)...
>>> Place this code below in a standard module:
>>> code below will open word better if you run 'Initial' once at first.
>>> Public WordObj as Object
>>> Sub Initial()
>>> Set WordObj = createobject("word.application")
>>> WordObj.visible = true
>>> 'do your stuff here...
>>> End sub
>>>
>>> Then place code below in ThisWorkbook module:
>>> Private Sub Workbook_BeforeClose(Cancel As Boolean)
>>> WordObj.Quit
>>> set WordObj = nothing
>>> End Sub
>>>
>>> --
>>> Regards,
>>>
>>> Halim
>>>
>>>
>>>
>>> "Patrick Penet" wrote:
>>>
>>>> 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" <(E-Mail Removed)> a écrit dans le message de news:
>>>> 0412F897-F66A-41D7-8310-(E-Mail Removed)...
>>>> > 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
>>>>
>>>>
>>>>
>>
>>
>
>

Here is a windows service that will kill all run away WINWORD.EXE after
a configurable amount of time.

http://www.spikesolutions.net/ViewSo...9-24e0-4942-8a
c4-2f78eda45469

*** Sent via Developersdex http://www.developersdex.com ***