Home |
Search |
Today's Posts |
#1
|
|||
|
|||
saving multiple sheets in a workbook
I have 1100 worksheets in a workbook all named after what I need to save them
as, but I can't find any kind of "bulk save" where Excel can take each of the sheets and save them as individual files vs saving them all in a workbook. I don't want to click on "Save as" for each of the files, then manually enter the name of the worksheet, especially since there is no hotkey assigned to "save as". Does anyone know of a way around this? Or perhaps a shortcut for doing it? |
#2
|
|||
|
|||
Hi
Try http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Danimal82" wrote in message ... I have 1100 worksheets in a workbook all named after what I need to save them as, but I can't find any kind of "bulk save" where Excel can take each of the sheets and save them as individual files vs saving them all in a workbook. I don't want to click on "Save as" for each of the files, then manually enter the name of the worksheet, especially since there is no hotkey assigned to "save as". Does anyone know of a way around this? Or perhaps a shortcut for doing it? |
#3
|
|||
|
|||
One way,
owb = ActiveWorkbook.Name For i = 1 To 11000 Workbooks(owb).Activate Sheets(i).Select wsname = Sheets(i).Name Cells.Copy 'Selection.Copy Workbooks.Add ActiveWorkbook.SaveAs Filename:="C:\Temp\" & wsname, FileFormat:=xlNormal, _ Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False ActiveWorkbook.Close Next i "Danimal82" wrote in message ... I have 1100 worksheets in a workbook all named after what I need to save them as, but I can't find any kind of "bulk save" where Excel can take each of the sheets and save them as individual files vs saving them all in a workbook. I don't want to click on "Save as" for each of the files, then manually enter the name of the worksheet, especially since there is no hotkey assigned to "save as". Does anyone know of a way around this? Or perhaps a shortcut for doing it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting multiple sheets | Excel Worksheet Functions | |||
Printing Multiple sheets | Excel Discussion (Misc queries) | |||
Exporting multiple sheets to multiple htm files? | Excel Discussion (Misc queries) | |||
how do i switch between multiple sheets in the same workbook (key. | Excel Discussion (Misc queries) | |||
How do I unhide multiple sheets? | Excel Worksheet Functions |