How to Close an Object

[Reggie Laffond]

Sorry if this has been covered. I can't seem to file any threads to answer
it. I've searched in multiple newsgroups.

I open Word with VBA in an Access 2000 app with CreateObject
("Word.Application"). After I have opened, printed and closed the document I
want, how do I close the instance of Word? It remains on the taskbar with no
documents open.

Thanks in advance.

 

[Herbert]

Hi,

I don't know if there is a better way but what worked for me was

obj.Application.Quit
Set obj = Nothing

I hope this helps,
Herbert

 

[Reggie Laffond]

Right on the money. Worked perfectly.


Thanks Herbert!