How to save sheets in new excel files, automatically?

[SuperDuck]

Hi.

I have an excel file that has about 300 sheets.

And every week, i will have a new excel file that has same proporties.
And i don't want to save sheets manually. Can i save all sheets in new
excel files?

For example;

My excel file name is: Excel_File

And the sheet names are;

Sheet_1
Sheet_2
Sheet_3
...
...
...
Sheet_300

I want to have 300 Excel files that has only "one" sheet and with the
names;

Sheet_1
Sheet_2
Sheet_3
...
...
...
Sheet_300

 

[Ron de Bruin]

Hi SuperDuck

Try this
http://www.rondebruin.nl/copy6.htm