Automating Excel

I am having problems automating Excel. I use Excel to
display and print a table from AutoCAD. From a user form
in AutoCAD I create an excel process and create the table,
then I make Excel application visible. The user form is
then unloaded and the object references to Excel are set
to nothing. Now, my problem is that I can't find the best
way to terminate the excel process. I want the user to
close and terminate Excel after printing. Right now it
always leaves the process running. Can someone tell me
which is the best way to do this? Should I start and
terminate Excel from the user form? TIA.

Hello John,

Since you start Excel fromthe Form, you should terminate Excel from the Form. Add the following code to your Form where appropriate.

Excel.Application.Quit

This will terminate Excel in an orderly fashion.

Hope this helps,
Leith Ross

"John" <[email protected]> wrote in message
news:[email protected]...
> I am having problems automating Excel. I use Excel to
> display and print a table from AutoCAD. From a user form
> in AutoCAD I create an excel process and create the table,
> then I make Excel application visible. The user form is
> then unloaded and the object references to Excel are set
> to nothing. Now, my problem is that I can't find the best
> way to terminate the excel process. I want the user to
> close and terminate Excel after printing. Right now it
> always leaves the process running. Can someone tell me
> which is the best way to do this? Should I start and
> terminate Excel from the user form? TIA.

Use Application.Quit