Close Excel which has error message

T

Tim

Hi folks,

I am developing a procedure which will check if the Excel application is
running or not. If it is running, close the Excel and continue the process.
I use the following code to close Excel application from Access. It works
fine if there has no error message. But, some time, I will get the error
message “Not enough system resources to display completely.â€. Then the
following code will not work. Does anyone not how to close the Excel
regardless the error message or not? Any help will be appreciated.

objExcel.Quit
Set objExcel = Nothing

Thanks in advance.

Tim.
 
Top