Actually you can read closed files using a query, you can set it up using
dataimport external datanew database query

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Peo Sjoblom" wrote in message
...
No.

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Graham F" wrote in message
...
Hi Group, I need to be able to read a block of cells, say a1:d10 on sheet
1
from a workbook without opening it, and then show the value of those
cells in
my currently open workbook. I know you can use links, but is there
another
way? Any help would be appreciated. Many thanks Graham.