Consulting

Results 1 to 2 of 2

Thread: webpage fx rates

  1. #1
    VBAX Tutor
    Joined
    Nov 2007
    Posts
    291
    Location

    webpage fx rates

    Hello,

    I am trying to get some exchange rates from a website. I have input all the input elements but it only gives me the default GBP USD rate but not the rate I want.

    This is what I have :-

    objIE.Visible = True
    objIE.navigate ("https://www.oanda.com/currency/converter/")
    Do
    DoEvents
    Loop Until objIE.readyState = READYSTATE_COMPLETE
    objIE.document.getElementById("quote_currency_input").Value = "Euro"
    objIE.document.getElementById("base_currency_input").Value = "Singapore Dollar"
    objIE.document.getElementById("end_date_input").Value = "Apr 6, 2019"
    objIE.document.getElementById("form_quote_currency_hidden").Value = "EUR"
    objIE.document.getElementById("form_base_currency_hidden").Value = "SGD"
    objIE.document.getElementById("form_end_date_hidden").Value = "2019-04-06"
    objIE.document.getElementById ("post")
    Do
    DoEvents
    Loop Until objIE.readyState = READYSTATE_COMPLETE

    Debug.Print objIE.document.getElementById("base_amount_input").Value


    Please help

    Many thanks
    Phil

  2. #2
    Yo. Those hidden parameters are not for processing the data conversion in the site you mentioned.

Posting Permissions

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