How to close word server

[Ondrej]

Hi everybody,

I am writing MS Access VBA application and I really don't know, hove to
close MS Word server, after all operations.

I start it in this way:
Dim oApp As Object
Set oApp = CreateObject("Word.Application")
oApp.Visible = True

How to close it?


... and sometime, when I close server by myself, it will not start again in
the future and I must to restart MS Access.
How can I detect, if server is already running?

Thanks a lot.

Ondrej

 

[Jonathan West]

Hi everybody,

I am writing MS Access VBA application and I really don't know, hove to
close MS Word server, after all operations.

I start it in this way:
Dim oApp As Object
Set oApp = CreateObject("Word.Application")
oApp.Visible = True

How to close it?

oApp.Quit 0
Set oApp = Nothing

.. and sometime, when I close server by myself, it will not start again in
the future and I must to restart MS Access.
How can I detect, if server is already running?

Try to access a running instance of Word using GetObject rather than
CreateObject. If that gives you an error, then try CreatObject. The
following article described more of this

Control Word from Excel
http://www.word.mvps.org/FAQs/InterDev/ControlWordFromXL.htm

The same code can be used from Access as from Excel.

 

[Ondrej]

Jonathan, thank you very much

Ondrej