MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Speed issues

Posted by Jim on April 19, 2001 8:49 PM

If a macro sequentially brings small bits of data into a workbook from several hundred different .xls files through VLOOKUPs, does it have to open the files one at a time in the background, get the data, then close them? Is there a preferred way to handle this type situation?

Posted by Malc on April 20, 2001 3:19 AM

Reckon I'd find another way than vlookups it'd take ages. Have you looked database functions though shared workbooks, templates or web wizard?
I don't think you'd have to open them but imagine the links.