Dear All,

I have the following array (variant): Row,FileName,Path,Use,Done with
about 5,000 rows in it.

I firstly fill the array columns Use and Done with the string "blank"
where there are any "empty" elements.

I then loop through each row, concatenate path & file and open the
file in read only that it corresponds to (there to ensure it exists).
It then reads a cell, writes it to another opened file and then close
the file.

My problem is that the macro suddenly stops (no debug error warning)
and random times, sometimes on file 35 or sometimes on file 435.

Any ideas why this would happen would be greatly appreciated.

Cheers

Mac