Automating Copying Workbooks

EB · May 2nd, 2002, 08:36 PM

I have a template workbook that I want to copy 200 times quickly into the same folder. I also want to individually name each file from a list (say in worksheet "Data") and also insert the corresponding unique number in cell E5 in each file. How do I automate this process with a macro?

Damon Ostrander · May 3rd, 2002, 11:14 AM

Hi EB,

Two questions:

1. Do you want the Data worksheet to be saved to all 200 templates?

2. What do you mean by "corresponding unique number"? Do you want just a number from 1 to 200 put in each template saved?

Damon

EB · May 3rd, 2002, 04:42 PM

It doesn't matter if the Data worksheet gets copied 200 times into each file although I don't need it to be.

Each file name would correspond with a 5 digit unique number which are somewhat random. My aim is to copy the file and insert the unique number into a certain cell to allow the workbook to index a database.

Thanks for your help.

Tom Schreiner · May 3rd, 2002, 07:00 PM

It does not sound very difficult DB.
A simple macro could be run from the workbook which contains your list and unique numbers.
This might be somewhat excessive trying to explain how to do this via the board.
Why don't you email me the book with the list, include information as far as the exact path in which the copies will be saved.
TsTom@HotMail.Com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 08:36 PM	#1
EB New Member Join Date: May 2002 Posts: 2	I have a template workbook that I want to copy 200 times quickly into the same folder. I also want to individually name each file from a list (say in worksheet "Data") and also insert the corresponding unique number in cell E5 in each file. How do I automate this process with a macro?

May 3rd, 2002, 11:14 AM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi EB, Two questions: 1. Do you want the Data worksheet to be saved to all 200 templates? 2. What do you mean by "corresponding unique number"? Do you want just a number from 1 to 200 put in each template saved? Damon

May 3rd, 2002, 04:42 PM	#3
EB New Member Join Date: May 2002 Posts: 2	It doesn't matter if the Data worksheet gets copied 200 times into each file although I don't need it to be. Each file name would correspond with a 5 digit unique number which are somewhat random. My aim is to copy the file and insert the unique number into a certain cell to allow the workbook to index a database. Thanks for your help.

May 3rd, 2002, 07:00 PM	#4
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	It does not sound very difficult DB. A simple macro could be run from the workbook which contains your list and unique numbers. This might be somewhat excessive trying to explain how to do this via the board. Why don't you email me the book with the list, include information as far as the exact path in which the copies will be saved. TsTom@HotMail.Com