To Access A Website And Copy Table

[robertrobert905]

Hi I'm doing some extremely repetitive work with a web tool at work. I need to import about 1800 tables for my first assignment and 5000 for my second.
I did a search on the forum and found out that Excel and vba is able to import tables from a website's chart which is amazing
I recorded a macro but it is unable to get all the charts that I need and here is the situation

The site that I'm using is confidential so I cannot show it but I have found a very similar website, the only major difference is that this site does not require a password but I do not think that this is an issue
http://www.billboard.com/bbcom/index.jsp
and from that site you can select charts near the top left
This is the billboard music charts
Say for example I want excel to import the number one song of every chart
(http://i25.tinypic.com/2bnvrd.jpg)

so if you look at the above image, that would be the drop down where you can select the different types of charts. So is there a way for vba to get me the number 1 single for each of these charts in the pic below
(http://i32.tinypic.com/2j0cxhg.jpg)

Thank you very much for the help everyone!

http://www.mrexcel.com/forum/forumdisplay.php?f=10