Download excel file from website

Hello everyone. I need some assistance to download excel file by type in date range in the following website using vba. To be honest, I don't really know anything about HTML, so if you can offer me some help, I will be really, really appreciated.

The website is http://research.stlouisfed.org/fred2/series/BAMLC0A0CM/downloaddata, and there are two text boxes that require me to type in start date and end date, and the website also allows me to download excel data within the date range.

So what I want is by typing in date range in my excel sheet, VBA can help me populate relative data in excel.

Please help, and thank you in advance.

Sir,

In this thread u suggested, how to select date and pull web data into excel.
http://www.excelforum.com/excel-prog...m-website.html

Similarly, Can u suggest a code, to import CSV into excel worksheet (say Sheet1) from a website (http://nseindia.com/products/content...q_security.htm) into single excel sheet, where before importing, the website ask

select a) type of data, (in given case - Security -wise Price Volume & Deliverable position data)
b) Enter Symbol: - (say - LT)
c) Select Series: - (Say - EQ)
d) Select a Time Period : (Say - From: 01Oct2013 TO 09Oct2013)

DAta should be kept from Cell C35 in Sheet1

Before importing new data (sheet may have been used earlier) any existing web query or data in from Cell C35, which should be deleted/cleared. So only the latest data appear in sheet1 from cell C35. Row 1 to 34 should not be disturbed, as that would be used for charting purpose.

Thank you for your reply, unfortunately this code didn't download data from the website. Instead, I got a run-time error '424' object required. Any suggestion?

Yes I did put dates in A1 and A2, (8/1/2013 in a1, and 9/1/2013 in a2) when I debug .Document.getelementbyid("obs_start_date").Value = Format(StartDate, "yyyy-mm-dd") is highlighted. The IE did open the correct web page. I do have IE loaded on my computer. And the references that I chose in VBA are the followings: visual basic for applications, Microsoft excel 14.0 object library, ole automation, Microsoft office 14.0 object library, Microsoft internet controls, and Microsoft HTML object library.