Excel error - retry, yes or no!

[Woodyuk]

I have an excel sheet which querys another excel sheet, every 10 mins. This sheet it querys, is produced automatically. I seem to get errors now and then, if the sheet is being updated. The error is along the line of "cant find book1.xls" it then asks if you would like to re try (yes or no), and will then continue once someone says ok.
Is there a way to put something in my macro to say, ignore that and try again in 1 min for example, with out the use of a human being?!?!?!?!?!

 

[Nareik]

Without knowing the finer details of your process I can only suggest that you use the application.enableevents= false before you load the data then use your code to trap for the error, then set a timer to repeat the load after a one minute interval.
Don't forget to set application.enableevents back to True as soon as possible after the offending portion of your code!

 

[Woodyuk]

This loads every 10 mins, and just needs to be left alone. I would like the report to just ignore this error or re run the macro.