View Full Version : Pull data from webpage

02-05-2016, 10:22 AM
Hello All,

I need a program which can pull data from a particular website after inputting certain data.

The webpage address is : " xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"

there are three tabs on the page.

First tab is location :

second tab has three dropdowns - boys, girls, and boys & girls

thrid tab is view report.

I have a list of locations eg. a, b, c, d, e, f, g, etc

need a macro which shall put one location on the first tab and select boys & girls and then slect view report and then extract that report in excel format.
and then continue to the second location and perform this operation.

Thanks a lot for the help in advance