View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Fredrik Wahlgren Fredrik Wahlgren is offline
external usenet poster
 
Posts: 339
Default Automating Excel


"John" wrote in message
...
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