Hi
I am trying to download the list of dealers from a website by punching zip codes stored in a excel sheet, automatically. I used excel VBA to do the following:-
1. create an IE object and open the weblink
2. Use getElements to locate textbox and submit button
Using this am able to successfully pick the zip code, put it in the text box and click submit button. The problem starts from here. After clicking the submit button a new internet explorer window opens showing the list of dealers. Now i am struggling to reference this new internet explorer window to copy data and close it thereafter.
Kindly help.
thanks
Bookmarks