Terminate Excel process

[Midger]

I have Word document containing few links to Excel sheet.
Excel workbook gets data from XML file.
In Excel I wrote macro Autpen 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

 

[Tushar Mehta]

It would be up to you to close the file and terminate the XL process.
Do so either in the Autpen 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