Get Currency from Web

Hi All

First time Ever doing web scraping...

I am wanting to extract USD to ZAR exchange rate

Any suggestions on how to get the correct element and change values...

Please Login or Register  to view this content.

Untitled.png

Using the URL you've given in your code, may be this;

Please Login or Register  to view this content.

You are an absolute star...Thanks Haluk...

Please Login or Register  to view this content.

It would be faster if you use API. You can register at this site for free https://currencylayer.com/ then to get API Key Access from Dashboard
Then this code can be used

Please Login or Register  to view this content.

Fantastic...Thanks Yasser

You're welcome. Thanks for the rep. points.

@sintek;

If you don't have to use the URL that you have given in your first message, then more effective alternatives can be offered as YasserKhalil has given in his message #5

Another alternative is; to get "Live Data" from investing.com without the need of a Web API, where XMLHTTP library is used.

In VBE, add the reference "Microsoft HTML Object Library" from "Tools>> References" menu. Then, run the code below:

Please Login or Register  to view this content.

Note: For different currency-crosses, all you need is to change the string in red color below accordingly (such as USD/EUR)

Please Login or Register  to view this content.

Thanks for all the options guys...