Using VBA to access website and take data from that...

[Syedali]

Hi Friends,

Am not new to macro but i don't have any experience in accessing website through Excel Macros.

I need to learn how to access web using Macro,

Example:

> I want to login website
> I want to select particular tab

like that any one having any tutorial or any sample files kindly share with me.

Thanks in Advance.

Syed

 

[Chihiro]

That really depends on the specific website and how it's security is set up.

http://dailydoseofexcel.com/archives/2011/03/08/get-data-from-website-that-requires-a-login/
http://stackoverflow.com/questions/25782351/unable-to-log-in-to-webpage-using-xmlhttp

General tutorial on web scraping.
http://analystcave.com/web-scraping-tutorial/