Seasons Greetings!

I have over 1800 workbooks (all the same format created by another
application using a template) which sit in a common folder on a server. I
now need to trawl through all these extracting specific ranges of data and
storing these in a new single workbook-sheet - one row per source workbook.

I am familiar with opening and copying data from external workbooks and
reading files sequentially in a folder. However is there a way to avoid
opening the remote workbook? Each are over 8Mb in size.

Thank you


--

Regards,
Nigel