Hello,
I'm attempting to scrape data from a web page. The screen scrape that I am using works fine. Here is a high-level overview of what it does and where I'm having problems:
1) Open up Internet Explorer (this works fine)
2) Log-in (this works fine)
3) Go to web page (this works fine)
4) Scrape the data (this works only if there is data to be scraped. If the data is non-existent, then the macro wants me to debug it).
I'm using ie.document.Links(Link# here).Click. If the link isn't there, then vba wants me to end or debug.
I'm thinking that the best direction is to tell VBA if no link number exists to pass it up and move on to the next.
Does anyone have any insight on the best thing to do here and how to do it?
I'm very grateful for any advice and practical code solutions.
I'm attempting to scrape data from a web page. The screen scrape that I am using works fine. Here is a high-level overview of what it does and where I'm having problems:
1) Open up Internet Explorer (this works fine)
2) Log-in (this works fine)
3) Go to web page (this works fine)
4) Scrape the data (this works only if there is data to be scraped. If the data is non-existent, then the macro wants me to debug it).
I'm using ie.document.Links(Link# here).Click. If the link isn't there, then vba wants me to end or debug.
I'm thinking that the best direction is to tell VBA if no link number exists to pass it up and move on to the next.
Does anyone have any insight on the best thing to do here and how to do it?
I'm very grateful for any advice and practical code solutions.