mercredi 6 juillet 2016

Web Page Scraping with Excel VBA

I am trying to get info from one of our company webpages. I wrote the code to get the info from page . let's say http://ift.tt/29n1QIl. But here is problem. When I try to visit that page directly from Internet Explorer, it directs me to; http://ift.tt/29jOLf6. So VBA Macro recieves that page. After the auto sign off the real target page appears. but InternetExplorer' document is already filled with login page's HTML code. Now how can I make excel get the data from the page that comes after autologin?

Thanks




Aucun commentaire:

Enregistrer un commentaire