View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tushar Mehta Tushar Mehta is offline
external usenet poster
 
Posts: 1,071
Default Excel automation

I am not sure I understand the problem. First you mention that you
leave the instance of XL open. OK, so XL should show up in Task
Manager.

Then you mention that you close it and it doesn't show up in the task
manager. As it shouldn't.

Then you mention that if you close the workbook XL is still running.
Shouldn't it be? The workbook is closed, XL hasn't been asked to quit.

To me it would appear that in each of the scenarios the system is doing
what you want it to do.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi all

I am automating excel 97 from Access 97. When I finish running all my code, I leave the instance of excel open but set all references to excel objects to nothing.

When I then close excel, excel.exe is not showing in the Task Manager processes. However, if I close the workbook, the instance of excel is hidden and excel.exe still shows in the Task Manager processes.

Has anyone come across this. I was thinking that maybe i had left some references to excel objects still valid but cannot find where I may have done this.

Would be grateful for any help.

Thanks
Michelle