Querytable/Web Queries problem - how to reset count and ignore errors

[Alexander_Golinsky]

Hi all!!

this is the code i use:

Please Login or Register  to view this content.

as the result i get 14 tables from web when what table it will be depends on dates in cells, say, Wq(2 + 20 * i, 9)

The problem is that when excel start count number of requests by this data table - i get no data. it looks like follow:?date=15.10_11, where 15.10 is the table name and 11 is number of requests. This think wont work but if i put only ?date=15.10 in cell and refresh then it works great. So 2 questions.

1 - how to prevent excel from counting and do query always like 1st time
2. My on error resume next doesn't work if i try request data that doesn't exist and i get nasty messages. How i really tell exxcel to ignore these errors??

Thanks in advance!

[Alexander_Golinsky]

Well, to prevent from counting it's must truly delete the QueryTable. the best way to go:

Please Login or Register  to view this content.

But how to ignore errors is still question... Turning off alerts doesn't help as well

[cdjindia]

What do you mean by "ignoring errors". If you truly ignored them, there would be no need for this query?

I am guessing that you are after something other than "On Error Resume Next".

You can use following function that you can run in Debug mode. In first run, pass deleteVal as false and press Ctrl-G during Debug mode to see names of tables.

Please Login or Register  to view this content.