Connecting between VBA Excel and web site

[Alexandr]

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:

Please Login or Register  to view this content.

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

[rwgrietveld]

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

[buran]

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.

[Alexandr]

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.

>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.
It is the question. How to modify the code?
>but it is paid service and I don't know if you have subscription
Unfortunatly I have not subscription

[buran]

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

Please Login or Register  to view this content.

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

[Alexandr]

Ok, I see,
Thanks a lot
and what about button "Search"? Can you help me to press it?

[buran]

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...

[Alexandr]

the cause is improving my knowledge, because I connected with other sites where I must use it via VBA, no other way.

[buran]

Unfortunately I'm not very familiar with HTML DOM

[Alexandr]

Ok, anyway thank you