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?!?!?!?!?!
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?!?!?!?!?!