How Do I Create Multiple Excel Workbooks Quickly

Date:2021-8-28 Author:Sandra

We have learned how to create multiple sheets in Excel, and how to batch create folders. Now, it turns to multiple Excel workbooks. If you are familiar with VBA, it’s a no-brainer for you. If you don’t, that’s okay. You can just save this post and take it out when you need it anytime.

Let’s take months as examples. If we need to create multiple Excel Workbooks and name them by month, from January to December.

Type months from January to December in cells A1 to A12.

How Do I Create Multiple Excel Workbooks Quickly

Now we click on the Developer tab and choose Visual Basic.

After we insert a module, we can type our code here.

How Do I Create Multiple Excel Workbooks Quickly

You can just copy and paste the code below.

Sub newbooks()

   Dim i&, p$, temp$

On Error Resume Next

Application.ScreenUpdating = False

p = ThisWorkbook.Path & “\”

For i = 1 To Cells(Rows.Count, 1).End(3).Row

temp = Cells(i, 1) & “.xlsx”

With Workbooks.Add

.SaveAs p & temp

.Close False

End With

Next

Application.ScreenUpdating = True

End Sub

How Do I Create Multiple Excel Workbooks Quickly

Now, click the green triangle or press F5 to run the code.

How Do I Create Multiple Excel Workbooks Quickly

It looks like the Excel worksheet had been refreshed a few times, 12 Excel workbooks with month names appear in the folder. I don’t think there’s a faster way, so remember to save this code.

If you wish to succeed, you should use persistence as your good friend, experience as your reference, prudence as your brother, and hope as your sentry.

See you next time.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *