Currency converter with VBA
Omar Boumahdi
The main window and the scraped data
After clicking on the macro shortcut either the button or symbol you get the following window:
The scraped data:
Data is then collected from a currency rates website and stored on an Excel sheet for use.
The conversion
After selecting the currency source and target, you enter the amount and also the date, after hitting convert you get the following result:
Last part: Plotting the data
if you select the plot data option, data from the last 30 days will be plotted in a new sheet created for the chart:
Like this project
Posted May 20, 2024
Currency Conversion project, using VBA to scrape the web for the necessary currency rates and then convert currency and plot results in a graph.
Likes
0
Views
12
