Connecting between VBA Excel and web site

Guys,

I have a some problem with connecting between VBA Excel and web site.
I wrote a macro to insert the data from excel but there is one problem with displaying the correct view.
I use this site to get the price of the bonds:
http://www.micex.com/marketdata/quotes
it is the site of russian exchange
First of all I write the ISIN code, for example RU000A0E6X12, in the "Quote Search" field and then press Enter for getting the data. After it I can choose the History information or Online from the last field in the left margin. I want to chose "History" and after it the dates from and till are appearing automatically. The automatization of it is my task. And I have only one problem in the end.
The program:

Sub DoBrowse2()
Dim TargetFrame As String
Dim IE As Object
Set IE = CreateObject("Internetexplorer.Application")
IE.Visible = True
IE.Navigate "http://www.micex.com/marketdata/quotes"
While IE.Busy
DoEvents
Wend
IE.document.getElementById("secid").Value = "RU000A0E6X12"
IE.document.forms(0).submit
While IE.Busy
DoEvents
Wend
IE.document.getElementById("data_type").selectedIndex = 1
While IE.Busy
DoEvents
Wend
IE.document.getElementById("date_from").Value = "01.03.2008"
IE.document.getElementById("date_till").Value = "01.12.2009"
IE.document.forms("Искать").submit
End Sub

There is the problem with the automated appearing of dates from and till. The line in the macro
IE.document.getElementById("data_type").selectedIndex = 1
choose the history information but the dates from and till dont appear. If you do it by hand it appears. Who knows the solution?
Thanks in advance for help

Please read the forum rules and use code tags. Go to your original post and use

HTML Code: 

Hi,
is it required to complete the task this way?
If you have a look at the site, after selecting "history" you will see that there is permenent link in the upper-right corner and it is like this

http://www.micex.com/marketdata/quot...7&boardid=EQNB

OK, It hides part of the link, but if you have a look at it, you will see that you can modify the link in your vba code and get the same result.

also there is possibility to download data in csv format via link

http://www.micex.com/issrpc/marketda...=10000&lang=en

but it is paid service and I don't know if you have subscription.

I modify code from here http://scriptorium.serve-it.nl/view.php?sid=30

Sub DoBrowse2()
    Dim objIE As Object
    Dim StartDate As String
    Dim EndDate As String
    Dim ISINcode As String
    Dim MyURL As String

    'Change next 3 lines to set ISIN code, start date and end date
    'i.e. use input from user, take values from cells or whatever the input is
    
    StartDate = "2009-01-01"
    EndDate = "2009-12-07"
    ISINcode = "RU000A0E6X12"

    MyURL = "http://www.micex.com/marketdata/quotes?secid=" & ISINcode & _
        "&data_type=history&date_from=" & StartDate & "&date_till=" & EndDate

    On Error GoTo error_handler
    Set objIE = CreateObject("InternetExplorer.Application")
    With objIE
        .Navigate MyURL
        Do While .Busy: DoEvents: Loop
        Do While .ReadyState <> 4: DoEvents: Loop
        .Visible = True
    End With
    Set objIE = Nothing
    Exit Sub
    
error_handler:
    MsgBox ("Unexpected Error, I'm quitting.")
    objIE.Quit
    Set objIE = Nothing
End Sub

This will navigate to the page, but I don't have idea how to retrieve the data.

Why do you want to do it via populating the form and press search? If you change the start date, end date and ISIN the result is the same...

Unfortunately I'm not very familiar with HTML DOM