+ Reply to Thread
Results 1 to 10 of 10

Connecting between VBA Excel and web site

  1. #1
    Registered User
    Join Date
    12-04-2009
    Location
    Russia, Moscow
    MS-Off Ver
    Excel 2007
    Posts
    5

    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:
    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
    Last edited by Alexandr; 12-07-2009 at 07:00 AM.

  2. #2
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    Re: Connecting between VBA Excel and web site

    Please read the forum rules and use code tags. Go to your original post and use
    HTML Code: 
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  3. #3
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Connecting between VBA Excel and web site

    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.
    Last edited by buran; 12-07-2009 at 07:25 AM.
    If you are pleased with a member's answer then use the Star icon to rate it.

  4. #4
    Registered User
    Join Date
    12-04-2009
    Location
    Russia, Moscow
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Connecting between VBA Excel and web site

    Quote Originally Posted by buran View Post
    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

  5. #5
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Connecting between VBA Excel and web site

    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.

  6. #6
    Registered User
    Join Date
    12-04-2009
    Location
    Russia, Moscow
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Connecting between VBA Excel and web site

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

  7. #7
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Connecting between VBA Excel and web site

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

  8. #8
    Registered User
    Join Date
    12-04-2009
    Location
    Russia, Moscow
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Connecting between VBA Excel and web site

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

  9. #9
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Connecting between VBA Excel and web site

    Unfortunately I'm not very familiar with HTML DOM

  10. #10
    Registered User
    Join Date
    12-04-2009
    Location
    Russia, Moscow
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Connecting between VBA Excel and web site

    Ok, anyway thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1