View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
john john is offline
external usenet poster
 
Posts: 97
Default 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.