Hi, I've been running an excel macro almost daily for a while now, and all of a sudden, it's giving me an error message:

"EXCEL.exe has generated errors and will be closed by windows.
You will need to restart the program.

An error log is being created."

The problem is that the macro is fairly elaborate and calls in other programs and a bunch of different workbooks, so I'm having difficulty pinpointing the problem. (Also, the macro runs fine if I step through it as opposed to running it.)

I'm sure that if I can find the error log that I can get to the source of the problem, but I can't find it. So, does anyone know where I can find the error log? If I don't have access to the error log, does anyone have any other ideas? Thanks!

You could try doing a Search or Find (from the Start Menu) on your hard disk for all files modified or created within the last day. That list might include a *.log file or something that looks like it might be what you want.

Thanks, DJ. I found it already though.

Yeah, sorry we took so long to come back to you Kathy32181 - this particular section of the forum doesn't yet have any one particular person looking after it - looks like we were all leaving it to someone else

Originally Posted by kathy32181

Hi, I've been running an excel macro almost daily for a while now, and all of a sudden, it's giving me an error message:

"EXCEL.exe has generated errors and will be closed by windows.
You will need to restart the program.

An error log is being created."

The problem is that the macro is fairly elaborate and calls in other programs and a bunch of different workbooks, so I'm having difficulty pinpointing the problem. (Also, the macro runs fine if I step through it as opposed to running it.)

I'm sure that if I can find the error log that I can get to the source of the problem, but I can't find it. So, does anyone know where I can find the error log? If I don't have access to the error log, does anyone have any other ideas? Thanks!

I am having the same issue on a win2000 machine with excel AND word. Same exact error. What was done to fix it?