Recent content by TBrewerton

Well i cant explain how i get the error better than what i have and it dosnt have a number but i will type the error word for word and describe its apperance. On the blue bar accross the top it just says Microsoft Excel In the grey message box to the left is an ! in a yellow trangile and this...

Hi, Thanks heaps for the reply and if i could get the first part you posted to work i think that could be what im after. The problem is though that it dosnt bring up an error number when i get that error... You would be able to see the error if you open a new book and create a web query of...

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...

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...

Hi, Ryan, im assuming this is done through excel... if so a way of doing what you ask would be to import the query to a different place maybe a new sheet or somewhere on the current one where you can hide it... now if you open up VB(a) and start a new module and put in this code... Function...

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...