how to work with internet explorer in Excel VBA

Question

hi All,

i've used vba in excel to exel only, now i want to work on internet explorer using vba, how to use html objects using vba, like how to click a button, how to click on a hyperlink, how to use menus of a site.

Can anyone please help me to know "how to work with internet explorer  in Excel VBA"

Thanks in Advance.

Regards

Nitin Pandey.

---

Er. Nitin Pandey.

Answer 1

Hi Er,

You can add a Webbowser control to your Excel document. and access Webbowser in you VBA application.

I hope it can help you,

Best Regards,

T.X.

Answer 2

Hi TX,

i am not able to understand what are you trying to say, i am totaly new to IE Automation through VBA. so i request you to please provide detailed information with code if possible.

Thanks 

---

Er. Nitin Pandey.

Answer 3

Here are some things to get you started:

http://www.jpsoftwaretech.com/excel-vba/automate-internet-explorer/

http://vbadud.blogspot.com/2009/08/how-to-login-to-website-using-vba.html

http://www.tushar-mehta.com/publish_train/xl_vba_cases/vba_web_pages_services/index.htm

 

---

Ryan Shuell