How to navigate Internet Page with VBA in excel

[Ratan Bhushan]

Hi Friends

I want to learn to navigate InterExplorer using VBA in excel.
For example: I want to open www.google.com
After that I want "YOUTUBE" tab to be clicked automatically or any other tab.

In my organisation, there is a website and we have to download data from there on the daily basis. I want to learn how can we do this or naviaget the IE from VBA Excel. Please help.

 

[Asheesh]

Hi Ratan,

Below are some of the links...these should help at least to begin with...

http://www.excely.com/excel-vba/ie-automation.shtml

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

http://www.makeuseof.com/tag/using-...-explorer-sessions-from-an-excel-spreadsheet/

 

[Marc L]

Hi !

Piloting IE is the slowest way.

QueryTable is faster.

The fastest way is to use an external request library (WinHttp, Xml) …
​