Faster response: Multiple workbooks open at once, or one at a time?

[jomili]

This isn't crucial, but a best practice kind of thing I'd like to know.

I have 15 budget analysts placed around the state, each with their own region. For the expenses for each region, each BA has one unique workbook. I'm frequently called to cull data from their workbooks and then run various routines on whatever subsection of data I'm looking for that day. My question is; would it better to open Workbook 1, copy the data I need, close workbook 1, open workbook 2, copy the data, close wkbook2 , etc. or would it be better to open Wkbooks 1-15, copy data from WB1, close WB1, copy from WB2, close WB2, etc? The second option is my standard routine right now, but it's fairly slow, so I've been thinking there may be a better way.

More details: Each WB is a pivot table. The source is a remote database, password-protected, to which I DON'T have access. So, for each WB I have to manipulate the pivot to get the information I need.

[TMS]

If it were me, and the workbooks all have the same structure, I'd have a list of the workbooks and loop through it ... open, process, close. Minimum loss of access for the users , minimum code (loop), and minimum memory overheads.

Regards, TMS

[jomili]

Hmm, what you say makes sense. Maybe I'll see if I can refigure my processes. Thanks for the input.

[TMS]

You're welcome.