I have a VBA macro that imports data from a long (600+)series of web pages into an Excel 2007 workbook.
There are occasional errors each time the macro is run such as: "The Web query returned no data. To change the query... etc." or "Unable to open... etc."
When these occur, a dialouge box with an "OK" button pops up and the macro waits until I click OK.
I'm looking for a modification to the VBA code that would ignore these web page access errors and let the macro run continuously through the long list of webpages to the end.
Thanks!
There are occasional errors each time the macro is run such as: "The Web query returned no data. To change the query... etc." or "Unable to open... etc."
When these occur, a dialouge box with an "OK" button pops up and the macro waits until I click OK.
I'm looking for a modification to the VBA code that would ignore these web page access errors and let the macro run continuously through the long list of webpages to the end.
Thanks!