Close Excel Application that opens when Access Database Open.

[deevaetodin]

I currently have an access database that relies on an Excel workbook for some complex calculations.

When the Access database is initiated, using script the Excel file is opened minimized by using an autoexec macro.

My question is how do I close the Excel workbook automatically when the database is closed.

The Excel application will automatically open from the start of the database, is there a script that I can use to save and close when the database is closed.

Thanks in advance for any and all help.

 

[gamesman]

refer to Microsofts KB q176391 at:

http://support.microsoft.com/support/kb/articles/Q176/3/91.ASP

how to programatically close another application.