On Tuesday, July 3, 2012 2:46:28 PM UTC+10, GS wrote:
After serious thinking David T wrote :
On Friday, June 29, 2012 6:52:48 PM UTC+10, Ggalla1779 wrote:
sounds like you need a database rather than spreadsheets

That's the correct sound... but it's required in Excel.


cheers

Have you tried reading the files via ADODB and writing the data to a
newly inserted sheet for each file? This would obviate having to open
the workbooks so the only tax on resources will be the newly added
sheets. (This assumes the same variable to store the recordset is
reused for each file)

I'll get back to you on that after discovering what ADODB is.


cheers