Error meesage if Report Stops

[rudevincy]

Hello,

I have created a workbook that generates reports. When the program runs there can be 600 reports that are created. It takes anywhere from 7-8 hours to create all reports.

I have noticed that sometimes during the run excel will freeze or stop, is there a way to build into the code that if the program freezes or stops any error message will appear to say the report number it stopped at.... example Message: Report stoped at Report 1111.

PLEASE HELP!

 

[pbornemeier]

Add code so before the beginning of each report, it appends the current date/time and name of the report being started to a text file. You can examine the file to see the report that was being run when the program froze.