Run Time Error 1004 - WebQuery

[marihouse]

I have a webquery that works.
I have it cycle through about 50 names and pull the information from the web for a range of dates for each name and import the data.

My problem is if I pull the data for all 50 names for August 1st thru September 30th, it works because there is a webpage of data for everybody within that timeframe. But, if I just pull data for say September 27th thru September 30th only 35 of them might actually have the web data page for that date range. So as it cycles through the names and gets to one that doesn't have data for that date range (the date range is part of the webpage address) then I get the runtime error 1004 and the page doesn't exist.

How can I tell it to skip over that page instead of the macro stopping with the error? I have no way of knowing which names have data or not for a specific date range and I am wanting to add to my current data and not wanting to do the entire set of available dates each time, because my lookups and formulas that are depending on the data makes it take too long to calculate once I have retrieved it. I just need the most recent data each time.

Thanks.

 

[John_w]

If this is a VBA webquery (or more accurately a VBA QueryTable object) trap possible errors with 'On Error' before the QueryTable .Refresh and check for Err.Number = 1004 and ignore it or tell the user or otherwise log the outcome.

 

[marihouse]

Thank you. That sounds like exactly what I need to do. Could you tell me what the code is?
I haven't seen that before. Thanks!

 

[John_w]

Have a search, or try this example - http://www.mrexcel.com/forum/showthread.php?t=402012

 

[marihouse]

Thank you SO much. That is just the help I needed. Works PERFECTLY!