Okay. Welcome to the Currency Converter project. In this screencast, I just wanted to show you what you're going to be making. I've got the units over here, the currencies that are available to the user. We've got the three letter code plus the description of it. So, when I run this, it brings up the currency converter user form. The user can select from this combo box, all of the different currencies over here on the left. So before we run this, before we open this we have to populate the combo boxes. We've got the combo box one here, the convert from and we've also got the convert to. And then I've got a field here were I can put in the amount so $10, we want to convert that to Euros. I can click convert. And when I click convert, it's going to go up to this website that I'll show you in some subsequent screencast. It's going to download the current data as of this date, the date that we specified. By default the date is just today's date, but you can change that if you want and I can press the convert button and it'll go onto the web, pluck the data, and it converts that to about eight euros. There's also this option that you need to put into your project which is plot the last 30 days. So, it starts with this day and by default, again, that's the current date and it goes and it's going to plot the last 30 days. Now this is going to take a few minutes because what it's doing is it's accessing the website for the last 30 days and it's bringing that data in here and then it's going to generate a plot. And in the end, you see that it has placed this plot onto this tab here, that tab I just kind of keep there, that's how this thing will work. So, it'll plot the last 30 days of that conversion factor. I wanted to just show a few things about this project at least the one that I've set up. I've got two hidden tabs behind here so if I right click and unhide, I've got sheet one. Sheet one is the sheet that we bring the important data into every time. So this is what happens, the data from the web is going to be imported into this sheet and if there's all this a bunch of this just extra garbage kind of beforehand but then starting here in cell 102, for this particular date. Now an important thing is that different days will start in different rows. It seems to not be consistent, so sometimes it'll start, you'll see the data start in A99, but other times it's in A102, like today. So it's different days there might be slightly different formats of this. So you need to somehow detect where the first currency code is. The one thing that is consistent is the currency code. So this whole table below is very consistent from day to day. When we run the sub it's going to unhide the sheet, it's going to import the data, it's going to find the data that you're looking for based upon the combo boxes, and then it's going to do the conversions and export that. And then, it has to hide this, so you have to have code in there that's going to rehide the sheet. I've also got a second hidden sheet called Sheet 2 and this is important for the plotting the last 30 days. And what happens is we put in today's date, so today is February 25th, and then we count backwards 30 days back to cell A1. And then, it goes through and for each one of these dates, it's going to open up and import the data from the web and it's going to put it next to it so this is $10 converted to Euros on January 27. In order to plot, and I'll talk about this more, you need to do something kind of interesting, you need to convert the date over here to an integer value and it's this integer value that you need to plot. But then, you can convert that to a date on the x axis. So it's a little tricky to plot dates but I'll show you how to do that in some subsequent screencast. And then at the very end of the plotting subroutine, you need to make sure that you're hiding this so it's always hidden from the user. When the user opens this up it's just going to have this currency convert and then also the plot. Another thing that your currency converter project should have is if you leave this amount blank, it will come up with some input validation. If you put in something like a string, it'll tell you that you can't enter text. And also, if you enter a negative value here, then it should detect that and let the user know that they can't input a negative currency. So, that's sort of just an introduction to the Currency Converter project. And let's go ahead and get started with the details.
