We can add a Workbook,
Workbooks.add just add a New Workbook.
I'm going to set that New Workbook,
that's going to be the Active Workbook as this variable aWB.
Now, I'm going to iterate through I'm going to recycle this j
variable and I'm going to iterate
through one to k. k again it's going to be the size of our N vector for each section.
So this, for the first one that's just two.
And when I open up
that New Workbook when I add that New Workbook we're just going to say,
"Range A and j,
so j will be one,
is equal to the first position of j."
j will be two then Range A two is going to be the second component of
vector N. So this here just takes our N vector and outputs it to the New Workbook.
And the last thing we need to do,
and I just recorded a marker for this.
I don't remember the code for this,
so I just record to save as.
We're going to just save that new file as a Workbook and this is just an "xlsx" Workbook.
I had to manipulate,
I had to change around this, the file path,
so the file path is just the folder that the user has defined earlier.
So this was with this this dialogue picker, this folder picker.
And I just did that concatenated it with now,
this is where you can define the file name.
I just said, "File_and concatenate that with the i variable.
Remember this still inside the i loop here which iterates through the sections,
and then I'm going to put that.xlsx on the end.
And finally we're going to close
that file and because I just saved the file right here in the line above it,
it doesn't really matter if this is true or false.
So that should do it.
Now let's go ahead and go through this.
We know that that part's working.
So I'm going to put a breakpoint there and let's go ahead and run this,
I'm going to run this.
We're going to choose our directory.
I'll say my section files.
And now we're going to iterate through one of these.
So, I have just created a new workbook up here and you see here it has book six.
When I go through this,
we see that it's already placed Max in here range A1 is equal to Max.
And if I go to the next one here then it places
Rodrigo there and then what it does is it saves that file.
I've already got a file in there so because I
didn't delete it the previous times when I was going to do that.
That won't happen, hopefully when you're running this,
but then we close that file and
we don't save changes because we just made changes right up there.
And then we can go to the next section two and we go through this.
I'm just going to run to cursor down here and it
opens up and creates a new file, a new book.
And then we export Joe and Shelly,
and we save that.
And again I didn't delete this from earlier so you shouldn't have that problem.
So looks like it's working.
I am going to go ahead and add these two lines Application.DisplayAlerts equals False.
In case, you do have a situation where you're trying to override a preexisting file,
you won't have that display,
that alert that just popped up a few minutes ago.
And I'm also going to Applications.ScreenUpdating equals False.
So you won't see everything happening
you'll just see the final product. So this is working.
Let's go ahead and run this.
Let me go back to my directory.
I'm going to delete all of these files and I'm just going to press "F5" to run.
We're going to choose the directory section files,
click "OK" and it goes through and just after
a few moments it's done and I can open up that folder,
and for example I can open up some file four and we see that we have Jimmy and Dana.
And if I go back to my original,
we see Jimmy four and Dana four.
And if I open up the other files we would see similar things.
So this screencast has shown how you can sort a roster file into section file,
you can create those files and store them and save them for later use.
In the next screencast, we are going to
open up each of these files so we're going to automate,
we're going to open up each of these files,
and we're going to add the headings onto here.
The first thing we're going to do is have to move these down or insert a row,
and then we're going to add the headings
so the different assignments. Thanks for watching.
