lovespar
12-19-2007, 12:04 PM
I am trying to update a Central workbook with data from 5 different WB's
This seems to be a common occurance here so I have been reading through the threads for some advice on how to create the code to do this.
I have the cells linked within my Macro but the cells change on a monthly basis. Thus I think I will have to repeat my Macro 12 times, referencing different cells each month. Then I can have the user pick the month she wants to Update.
It seems the codes run much faster if the source WB's are open.
Why is this? Should I open each source WB in the code before the transfer?
Thanks
This seems to be a common occurance here so I have been reading through the threads for some advice on how to create the code to do this.
I have the cells linked within my Macro but the cells change on a monthly basis. Thus I think I will have to repeat my Macro 12 times, referencing different cells each month. Then I can have the user pick the month she wants to Update.
It seems the codes run much faster if the source WB's are open.
Why is this? Should I open each source WB in the code before the transfer?
Thanks