On Error Resume Next
blnWeCreated = False
Set myWord = GetObject(, "Word.Application")
If myWord Is Nothing Then
blnWeCreated = True
Set myWord = New Word.Application
End If
That way you know if you want to shut it down when finished.
"McKilty" <bluesbrthr@gmail.com> wrote in message
news:d83703e0-3281-40ef-a3f6-d62024fd923f@a7g2000yqo.googlegroups.com...
> Thanks.
>
> I'm not sure if this is the best solution either, but it works better
> than what I was doing.
>
>
> On Error Resume Next
> Set myWord = GetObject(, "Word.Application")
> If Err.Number <> 0 Then
> Set myWord = New Word.Application
> End If
> On Error GoTo 0