Hi all,
I've set up a web query in VBA, which works fine, but I'd like to know if and how I can access the data within the query directly from VBA.
I think it uses a recordset but can't seem to get to it, I'm not too skilled at the topic.
Point is that I retrieve all tables from a web page. Although the data I use are usually in table #5, sometimes they go to another table. Therefore, after the web query, my code would go to table #5 and look for the data there. Only if it doesn't find it there should it try to search for it in other tables...
Hope someone can help
Best regards and thank you for your time.
Miguel.
I've set up a web query in VBA, which works fine, but I'd like to know if and how I can access the data within the query directly from VBA.
I think it uses a recordset but can't seem to get to it, I'm not too skilled at the topic.
Point is that I retrieve all tables from a web page. Although the data I use are usually in table #5, sometimes they go to another table. Therefore, after the web query, my code would go to table #5 and look for the data there. Only if it doesn't find it there should it try to search for it in other tables...
Hope someone can help
Best regards and thank you for your time.Miguel.
