How do I get rid of multiple instances of Word

[LegalIT]

Hello,

I have a VB.net application that creates reports from database information. I am able to create the reports fine. The problem is each time I create a report my application starts a new instance of Word instead of just adding a document to the current application. I use the following code to create each report. If I take the New out I get an error.

Dim objWord As New Word.Application
objWord.Visible = True
objWord.Documents.Add()
objWord.Selection.TypeText("Report Created - " & Now())
...
objWord = Nothing

Anyone know how I create multiple Word reports without creating multiple instances of Word?

Thanks!
LegalIT

[kadghar]

First of all, i'd recomend you to create only one word instance, the first time, later times just call it

dim obj1 as object
Sub bla_bla()
set obj1 = createobject("word.application")
'your code for new reports
end sub

this way you'll only have one instance.

Now, if you dont have many instances at the same time, just dont close it
and make it visible (as you have allready done) and leave it opened, then simply close it the normal way, by clicking the upper right button.

This issue has been discused many many times around here, and for some reason, most of the solutions just dont aply to all users. So leaving the instance visible and open, and closing it manualy is the 'for sure' way of getting rid of it.

HTH

[LegalIT]

Thank you for your suggestion. It worked great!