Worksheet to new file
 

I have more than 100 worksheet in a sheet and i want to save this worksheet
as workbook at once. I can do I one by one. Please help me on this.

Jai

Worksheet to new file
 

Hi,

Could you elaborate a bit.

I assume 100 worksheet in a Workbook and not 100 worksheet in a sheet.

Caution:
There is no command as Save ALL. You can close all the Workbook you have
opened, by pressing the Shift Key and then selecting the Close All command
from the File menu.

Challa Prabhu

"jai" wrote:

I have more than 100 worksheet in a sheet and i want to save this worksheet
as workbook at once. I can do I one by one. Please help me on this.

Jai