| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split workbook into multiple workbooks
That was perfect! Thank you very much!
Dave Peterson wrote: This line: Set Sourcewb = ThisWorkbook says to use the workbook with the code. If that's not what you want, you can keep the code in your personal.xls workbook, but change the line to: Set Sourcewb = ActiveWorkbook Just make sure the workbook that should be split is active before you run the macro. I have a workbook with 95 worksheets in it, and I'd like to be able to split these out into individual workbooks. I looked on Ron DeBruin's site and got [quoted text clipped - 99 lines] -- Message posted via http://www.officekb.com -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200912/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split workbook into multiple workbooks | Excel Programming | |||
| Split Workbook into Multiple Workbooks | Excel Programming | |||
| Split data from 1 workbook into multiple workbooks based on criter | 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) | |||
Threaded Mode
