Logo 
Search:

MS Office Forum

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Web Query Error

  Asked By: Fern    Date: Nov 21    Category: MS Office    Views: 717
  

I have a series of macros that run different web queries. If the
query is not found (because there is no data on the webpage) it errors
out (run time error 1004). Is there a way to tell the macro to ignore
this error and go to the next sub. Also I would need to delete the
old data that is in the cells for the query otherwise the old data is
referenced.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Fareess Khan     Answered On: Nov 21

I'm not 100% sure this will work with web  queries, but
if you use:

On error  Resume Next

prior to the call, you can then test the Error number:

if (Err.Number <> 0) then

to deal with errors.

 
Didn't find what you were looking for? Find more on Web Query Error Or get search suggestion and latest updates.




Tagged:      

 
 
 
 

Related Post