Vba to extract data from a web site

Hi all , this is my first post I hope I get across my idea clearly ( my first web VBA please be gentle ):

What I want to achieve:

1) open a web page http://www.bmreports.com/bwh_Mid.htm
2) insert date and period in the text box and click "go"
3) once the data is displayed I need to import them in eirther excel or access

I found lot of problem in inserting data and periods in the textbox , unfortunately the web queries are not displayed in the browser
Below the code I have used :

Please Login or Register  to view this content.

below the web code:

HTML Code: 

You don't need IE automation and HTML DOM parsing to extract this data. Instead, a web query is the simplest way, as long as you specify the correct parameters and values in the query string (the part of the URL after the ? character). Something like this:

Please Login or Register  to view this content.

That's just a web query generated by the macro recorder and I tweaked the code to declare the URL string. In this example I hard-coded the date (param0) and period (param1) values, but you will want to specify your own values from user inputs. Use Format function to format the input date as yyyy-mm-dd: Format(theDate, "yyyy-mm-dd").