| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Include Worksheets From Workbooks into ONE new Workbook
II have 5 Workbooks. Each have one worksheet. I want to create a new workbook that includes each of the worksheets from each of the five workbooks. how do i do that? One problem I forsee is that each of the worksheets are named "Sheet 1" by default. thoughts? thanks. -- tcgaines ------------------------------------------------------------------------ tcgaines's Profile: http://www.excelforum.com/member.php...o&userid=29608 View this thread: http://www.excelforum.com/showthread...hreadid=493857 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Include Worksheets From Workbooks into ONE new Workbook
Hi tcgaines
Try http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "tcgaines" wrote in message ... II have 5 Workbooks. Each have one worksheet. I want to create a new workbook that includes each of the worksheets from each of the five workbooks. how do i do that? One problem I forsee is that each of the worksheets are named "Sheet 1" by default. thoughts? thanks. -- tcgaines ------------------------------------------------------------------------ tcgaines's Profile: http://www.excelforum.com/member.php...o&userid=29608 View this thread: http://www.excelforum.com/showthread...hreadid=493857 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Include Worksheets From Workbooks into ONE new Workbook
Maybe if you also disable the events it is faster
Before the loop Application.EnableEvents = False and after the code is ready Application.EnableEvents = True -- Regards Ron de Bruin http://www.rondebruin.nl "tcgaines" wrote in message ... perfect!!! i dont know why its soooo slow (about 3-4 minutes) but it works!! -- tcgaines ------------------------------------------------------------------------ tcgaines's Profile: http://www.excelforum.com/member.php...o&userid=29608 View this thread: http://www.excelforum.com/showthread...hreadid=493857 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Include Worksheets From Workbooks into ONE new Workbook
Depending what your code is up to sometimes turning calcualtions off wile the
macro is running will speed things up. As with any application level events it is best to include an error handler when you modify these settings (Calculation, Alerts, Events)... Sub DoYourStuff() on error goto errorhandler application.calculation = xlManual applicaton.enableevents = false 'Your code here ErrorHandler: application.calculation = xlAutomatic applicaton.enableevents = true End Sub -- HTH... Jim Thomlinson "tcgaines" wrote: perfect!!! i dont know why its soooo slow (about 3-4 minutes) but it works!! -- tcgaines ------------------------------------------------------------------------ tcgaines's Profile: http://www.excelforum.com/member.php...o&userid=29608 View this thread: http://www.excelforum.com/showthread...hreadid=493857 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Include Worksheets From Workbooks into ONE new Workbook
perfect!!! i dont know why its soooo slow (about 3-4 minutes) but it works!! -- tcgaines ------------------------------------------------------------------------ tcgaines's Profile: http://www.excelforum.com/member.php...o&userid=29608 View this thread: http://www.excelforum.com/showthread...hreadid=493857 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I write an array to include all worksheets in a workbook? | Excel Worksheet Functions | |||
| 2 Workbooks and 6 Worksheets - Need to Populate 1 Workbook | Excel Worksheet Functions | |||
| Copy range from multiple workbooks and include workbook name | Excel Programming | |||
| Copying Several Workbooks into one Workbook as Worksheets | New Users to Excel | |||
| Is it possible to include Excel worksheets/workbooks into COM Addins ? | Excel Programming | |||
Linear Mode
