Creating multiple excel files based on list of items

Hi everybody,

I have a list of 500 items as an excel file. The name of each item is saved in the column A of the excel file ItemList.xlsx:

Item1
Item2
Item3
...
Item500

I need to write a macro which will create an empty excel file for each item and give each file the same name, as the name of the item. So at the end I need to have 500 excel files named Item1.xlsx, Item2.xlsx, ...Item500.xlsx.

Could you please help me?

Hi AlexeyY,

Welcome to the Forum!

I put them all in the same folder as the calling routine - hope that works

Please Login or Register  to view this content.

If you haven't used macros before you'll need to go to:
File- options - trust center -trust center settings - macro settings ,
the second option down (disable all macros with notification)

Then - Copy the code to the clipboard

Open your Workbook

Press ALT + F11 to open the Visual Basic Editor.

Select "Module" from the Insert menu

Type "Option Explicit" then paste the code under it

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name
*Be sure to save the book with the code as Macro-Enabled

You're welcome and thanks for the rep!

The code above should be built in into the excel file with the list of items.

That's not necessary - you could have the code in any workbook - I suggest an utility book with codes.

Notice that it creates another book from the "ActiveBook" not "ThisBook".