Show Buttons
Share On Facebook
Share On Twitter
Share On Google Plus
Share On Linkdin
Share On Reddit
Contact us
Hide Buttons

VBA-Excel: Working with Internet Explorer

You can per­form var­i­ous oper­a­tion on Inter­net Explorer (IE)  using your excel, like Launch IE browser, nav­i­gate to spe­cific URL, Click on Images on IE, set­ting text in input box or web edit and many more.

Since its and exter­nal appli­ca­tion, to deal with it first step would be get the instance of the word file or you can say cre­ate the Object of the word file using Cre­ateOb­ject Function.

Set objIEBrowser = CreateObject(“InternetExplorer.Application”)

And that’s it Now you are all set to per­form var­i­ous oper­a­tions.

In next few ses­sions you will see the fol­low­ing oper­a­tions on Word using Excel.

Happy Macro­ing :)

Sumit Jain

 

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: