Import HTML table into Excel

[ms1109]

I am familiar with VBA, but this one has me stumped! Basically, I want to have Excel fill out an Aspx form, submit it, and then pull in the data from the html table that the form produces. There are multiple queries it would have to do, so I would want it to loop through until it is done with my list of inputs. Is this possible?!? I don't even know where to start...

The website I need to pull data from is: http://www.usac.org/hc/tools/disbursements/default.aspx

On the form, there are multiple fields, but the one I am interested in is the "Study Area Code." An example input I would have in this field is "529910." I would have a different sheet in my workbook with all the SACs I need to pull.

My vision for the end result is to have all the data pulled into one sheet. Can anyone give advise/help?

Thanks,
Matt

 

[jalipin]

Hi Norie,
I wonder it is possible to do this in the other way around?
I want to transfer data form excel to the HTML.
Appreciate your help.