Hi

I wonder if someone could give me some advice.

I have a macro1 that loops continuously with no exit loop. It's purpose is, for each item on an Excel list, check if 2 "text" files exist on the network. These 2 files are produced at different times. If the 2 files exist, then if another Excel file (ExcelFile1) does not exist, then create and refresh ExcelFile1.

The purpose of the macro is to create the ExcelFiles as soon as the text files are available and this macro will mostly be run overnight.

The macro seems to work well for a couple of hours but the parent excel file that runs the macro1 (including the application) then closes with no error or warning.

Is there a way to make the Excel application more stable? I am wondering whether there is a maximum number of times that Excel will allow looping?

Thanks