Foreign currency conversion using VBA

blu817

New Member
Joined
Aug 18, 2017
Messages
18
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

Well-known Member
Joined
Sep 21, 2016
Messages
2,650
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

New Member
Joined
Aug 18, 2017
Messages
18
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.
 

Forum statistics

Threads
1,081,560
Messages
5,359,608
Members
400,538
Latest member
leon_oscar

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top