Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with Incative Workbooks
Hi there -
I am trying to make some code more efficient. Currently, I have a workbook that is opened via MS Scheduler, a Workbook_Open Event starts a macro that opens approximately 7 report workbooks and updates those with approx 16 data files. According to what I have read, it is much more efficient to leave as many files as possible inactive and just pull the data. However, I am at a loss as to the proper way to focus on the inactive workbooks as I need them. I have Dim'd them all as: 'data files Dim df_One as string Set df_One = Workbook("dataOne.xls") 'onward til all are named 'report files Dim rpt_One as String Set rpt_One = Workbook ("reportone.xls") 'and so on Now lets say I want to work with data from df_five.range(c1:ba1009) copy it to rpt_six, then get data from df_two.range (a2:c1010) and copy it to rpt_six. What is the most efficient way to accomplish this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working with 2 workbooks | Excel Programming | |||
Working with Different workbooks | Excel Discussion (Misc queries) | |||
Working with Different workbooks | Excel Discussion (Misc queries) | |||
Working with two workbooks | Excel Programming | |||
Working with Two WorkBooks | Excel Programming |