I'm using a macro to close Excel, but then I get the "Microsoft Excel has encountered a problem and needs to close........" message. I went to the system properties - Advanced - Error Reporting and clicked the Disable Error Reporting radio button and also UNchecked the "notifiy me when critical errors occur". I am still getting the messages though when I run my macro to close Excel. This is Excel 2007 running on Windows XP Pro.

What type of macro is it? Eg, what did you write it in, it's possible there is a conflict between Excel and the macro.

Try,
Enable/Disable Error Reporting in Windows XP
to disable error reporting under XP

__________________

</Dream In Code>
-William. § (marvin_gohan)

Thankyou for the reply William.

I'm not sure why I was getting the "Send error report" after I disabled error reporting.

I rewrote my macro and the problem doesn't occur now, so it's possible that it was an Excel/Macro issue...

The part that was causing the problem was a task kill function. I called it in a batch file from the macro to close Excel. I'm still doing it, just in a different order, and now I don't get the error. Here's the part that was causing problems:

taskkill /im EXCEL.exe /f

Thanks anyways though!!!

Interesting, the line doesn't appear to be something that should cause an error, but if timings were wrong and excel was blocking at the time, it could force the application to close anyway, which the OS (Windows) interpreted as an error for some reason.
The fact that you received errors after disabling them is just a sign that even M$ programmers are not all experts, lol.

Glad your problem is resolved

__________________

</Dream In Code>
-William. § (marvin_gohan)