How to save sheets in new excel files, automatically?
 

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

How to save sheets in new excel files, automatically?
 

Hi SuperDuck

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"SuperDuck" wrote in message
...

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