Create 100 copy of a excel file with unique name

[kakero]

Hi

I want to make 100 copies of an excel file with unique name( 1,2,....100) and paste them into a folder in my computer

i want also link the name of file ( 1,2,...3) into a specific cell in each file

for example :
the name of first copy is 1 and the Cell A1 is also 1
the name of second copy is 2 and the Cell A1 is also 2
the name of third copy is 3 and the Cell A1 is also 3
.
.
.
the name of 100th copy is 100 and the Cell A1 is also 100

is it possible to do it with VBA?

Thank you so much

[Pepe Le Mokko]

Some suggestions you may fund useful:

1. Our answerers are looking to "help" more often than they are looking to "do an entire project for you for free".
2. Jump into this project yourself, when you get stuck on ONE specific hurdle, post that ONE item as a forum question.
3. Show us what you've tried in an attached sample workbook and how it's not working for you. When you're doing the work yourself, just writing out a complete example question in a forum often points you to solution before you even finish posting.
4. If you can't make any headway at all and no help is forthcoming in the free forum(s), we do have a Commercial Services forum where you can pay for assistance directly from our EF gurus."

[karmapala]

Assuming that the sheet which will contain 1,2,3,4 and so on in cell A1 has no data (blank) and the name of this sheet is "Sheet1":

Please Login or Register  to view this content.

The "num" line is to have a text number like 001 002 003 for naming the copied file,
in order the copied files will sort-name correctly in the target folder.
The 100 copied files will be placed in drive D folder target, so this must be prepared before hand.
The ActiveWorkbook is the file to be copied 100 times.

The macro is in the ActiveWorkbook which already saved with xlsm extension.

[kakero]

Thank you so much