| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Detach different WORKSHEETS in one WORKBOOK into DIFFERENT WORKBOOKS
Good to hear.
Gord On Sat, 11 Aug 2007 21:45:35 GMT, "Mr BT" wrote: I figured it out. I added something to the end of the saveas line ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\" & w.Name, FileFormat:=xlCSV, CreateBackup:=False |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 Workbooks and 6 Worksheets - Need to Populate 1 Workbook | Excel Worksheet Functions | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| Can I split worksheets from one workbook into individual workbooks | Excel Discussion (Misc queries) | |||
| Can I tile worksheets within a workbook, like one tiles workbooks. | Excel Discussion (Misc queries) | |||
| Copying Several Workbooks into one Workbook as Worksheets | New Users to Excel | |||
Hybrid Mode
