Thanks for the clarity between 1-2-3 and Excel, I could have spent ages
looking.

Are there other ways of getting data in say a known range name from one file
into another without opening the data file?

Thanks, Robert


"Jim Rech" wrote in message
...
There is no File, Combine command in Excel like in old 1-2-3. Old 1-2-3
needed this because only one file could be opened at a time. But there is
no such limitation in Excel. So, open each workbook and copy from it,
pasting into the consolidation workbook.

--
Jim Rech
Excel MVP