Terminate Excel process

M

Midger

I have Word document containing few links to Excel sheet.
Excel workbook gets data from XML file.
In Excel I wrote macro Auto_Open where I auto update Excel fields and
then save the Workbook.
Its work good. Except one- when I close the Word Application the Excel
process does NOT terminate.
When I try to open it again, the file is already open.
How to close this background process.

Midger
 
T

Tushar Mehta

It would be up to you to close the file and terminate the XL process.
Do so either in the Auto_Open code or through code in the Word document.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005
 
Top