Foreign currency conversion using VBA

[blu817]

I do a daily process that requires me to take foreign currency values and convert them into US dollars (USD). For example A1 has the amount of .38 and B1 would have CAD (Canadian Dollar). I then would go to the website XE.com for the conversion rate, search for CAD converted into USD. Take that value and put into C1 =A1*the conversion rate. I was wanting to know if it was possible for VBA to access a third party website like VBA to do the math. Or if there was a way for me to just type in the conversion rate in a message box and have it do the math. I am open to any suggestions and any guidance would be greatly appreciated.

 

[footoo]

Probably the easiest way is to use a website that allows the creation of a customized currency portfolio/watchlist which can be downloaded (e.g. Yahoo Finance).
The calculations could then be based on the downloaded info.

 

[blu817]

Thanks for the idea, it actually led to me to look at this problem from a different angle. This solution was probably the simplest way to solve this.