• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Convert currency from webpage

Thank you Chihiro, but we don't need to pay for this site. As am able to access it. I just want a macro which will convert currency automatically as per mapping provided in excel
 
@Surekha

It isn't very clear to me what you need. Please upload sample workbook with your set up. Along with initial values and what the end result should be (or what information from the site is used for the operation).

Generally speaking, for speed and reliability, I'd recommend using API rather than piloting IE.
 
My requirements are as below
Currency to convert. USD amount
10eur
5gbp
12 afn
45eur

In excel columns user will update there values with currency we just need to convert those amounts to USD from OANDA site only
 
Then, I'd recommend paying for API. Other than that, you may have luck with piloting IE. Though I wouldn't recommend it.

That site, uses scripts and queries to fill web page, along with timed cookie. So standard XMLhttp, Winhttp etc won't work here.
 
Thank you Chihiro for your suggestions. But now am able to automate this site through vba. I will try to upload the code for reference if possible.
 
You must log in or register to reply here.
Back
Top