TBrewerton
Technical User
Hi, ive got a spreedsheet in excel that has a multiple number of web querys in it, all doing verious different things, some update hourly others on the minute. The problem im incuring is that about 6 times out of 10 the refreshed data comes up with the error "No data collected" well along those lines anyway...
I want a macro or script that can run through VB(a) that does the following,
On a refresh if it encounters such error as stated above, it will click ok on the error and refresh the item that encounted the error again until it finally recieves the data, then move on to the next query... Either that or just as good would be for it to work for a single query so refreshes/closes the error window until data is recieved.
In Advance thankyou very much!
If you dont quite understand go into Excel and create a web query of anything then right click it and refresh im sure after doing it a couple of times you will encounter the same error.
In Advance Thankyou so much,
Tim
I want a macro or script that can run through VB(a) that does the following,
On a refresh if it encounters such error as stated above, it will click ok on the error and refresh the item that encounted the error again until it finally recieves the data, then move on to the next query... Either that or just as good would be for it to work for a single query so refreshes/closes the error window until data is recieved.
In Advance thankyou very much!
If you dont quite understand go into Excel and create a web query of anything then right click it and refresh im sure after doing it a couple of times you will encounter the same error.
In Advance Thankyou so much,
Tim