Replies

Thanks for all the help.

Dylan

Rory,

This is quite a generic piece of code which I use for any programs that need to control Excel. After I have created an object variable that represents an instance of Excel (using the function you tested), regardless of subsequent code that runs the problem remains the same.

Thanks for the SendMessage suggestion, I’ll look into this.

No, code is only running in the program that is controlling Excel.

Thanks

Yes, I am releasing the object variable that stores the value that the function returns, but this still does not release Excel. Obviously, after you have finished automating Excel, the session of Excel would remain open for the user to work in. It’s when they close the workbook (If there’s only 1 workbook open it, closing the workbook will terminate Excel!) or the Excel application that the application actually remains in process. Only closing the Application that automated Excel seems to destroy the process??