I'm again going to be working with these files. File_1 through File_5 in this screencast. If I open up just a representative, one of those files, we see that in range C5 through F10, we've got a bunch of integers. And what I want to do, back on my main file here, I want to create a subroutine that's going to open up all those files, and then it's going to count the total number of 7's in C5 through F10 of all five workbooks. So, the first step here is going to be similar to the previous screencast. So I've got a Dim FileNames as a variant, that's going to allow the user to select the files, that they want to count the number of 7's in. We have nw as the number of workbooks. Same as in the previous screencast, we're going to Dim i as Integer. We have this new integer c, that's going to be the running tally of the number of 7's. And we're doing kind of the same thing with the workbooks so we don't get confused. And we're going through here, and we've entered into this For loop. So this For loop, is basically what we're going to be doing once we open up each of the workbooks in the FileNames vector. So when we iterate through each workbook, we're going to iterate through rows and columns. So, I'm going to add two more integers, j and k. Those are both dimmed as integers. So one at a time, we're going to open up each workbook. And then going to set, aWB equal to ActiveWorkbook. Next, we're going to go through a nested set of For loops, and we're going to count the number of 7's in that range, range C5 through F10. So I have my inner and outer For loop here. We have outer For j equals 1 to 6, we're iterating over the six rows of range C5 to F10. Then, we have For k equals 1 to 4, we're iterating over the columns of each of those rows. Now, what we're going to do is we're going to see if the individual cell of that range, of that workbook is equal to 7. So to check to see, if an individual cell of range C5 to F10 of Sheet1 of the active workbook is equal to 7, we can use this statement. If that's true, then the count is just going to be count plus one. And then, we need to go ahead and close the Workbook. We're going to close that Workbook without saving any changes. And then we go to the next i, which is the next Workbook. So, we open, we set the active Workbook to the ActiveWorkbook. Then, we iterate through range C5 to C10 of Sheet1 of that active workbook, to check to see if it's seven, if that's true we add one to our account and we keep going, and at the very end then the only thing we have to do is to, we're just going to message box this. Now, for now, I'm just going to put an apostrophe here. We're going to disable that application screen updating equals false. So we can go through this, one line at time. So, I'm going to put a couple of break points in here. And then, we can sort of see what's going on. So I'm going to press F5. We obtain, the user can select the different files. And now, I'm going to open up the first workbook and I can open it up here. We see then, let me expand this a little bit. We don't encounter the first seven, until we're at second row, second column. So we can go back here and I'm going to press F8. j right now is one, which is the first row. We're going through all four columns. Now we're in the second row. We're in the first column right now, but then we bump into the second column and looks like that's what we want. We want to count then the two, two position. So now, our count is equal to one. We found one 7, and I'm quite confident that it's working now. So, I'm going to just put my cursor down here and do debug, run to cursor. So we just, watch and wait and it opens up all the other files. Actually, I have a breakpoint here so, I'm going to just press resume, and I'm going to have to do this a couple more times. It's opening up each of the workbooks and counting. And finally, when we're done, it outputs the total number of sevens in all of the workbooks and we end up with eleve. So this is another example of how we can use VBA code, to get information from multiple workbooks and we can automate this. And if you want to, you can eliminate that apostrophe to make it so the screen updating is false. And I can remove that breakpoint in just, in one fell swoop. We can select the files we want to count, the number of sevens in and it goes and then it outputs the result. Thanks for watching.