View Single Post
  #1   Report Post  
SuperDuck
 
Posts: n/a
Default 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