Hi Jason,
Are the files located on another machine? A server maybe?
Adding a "DOEVENTS" between files should take care of any network timing issues.

John


wrote in message ...
Hello All,

I've got a difficult problem to analyse.
My program opens many workbooks (~40) one at a time then moves data
into each; does a refresh; and then saves the workbook. This all
happens in a second instance of Excel.

Problem is that it has started to just stop half way through with no
error message - I'll activate the instance of excel and one of the
mentioned workbooks will be open in design mode....with no clue as to
why!!

It takes about 25mins all in so stopping after 15mins of success is a
pain.

(Sometimes I can re-run and all will go through ok)

Anybody got any ideas, or experienced anything like this before?

Any help much appreciated
Jason