Reading values from a closed workbook

[Graham F]

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.

 

[Peo Sjoblom]

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

 

[Peo Sjoblom]

Actually you can read closed files using a query, you can set it up using
data>import external data>new 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

 

[Ron de Bruin]

With code you can do this
http://www.rondebruin.nl/copy7.htm

Or
http://www.rondebruin.nl/ado.htm

 

[Graham F]

Brilliant! Many thanks Ron, I now have all the information, and alternatives
I need! Graham

 

[veek]

is there a way to link to an entire worksheet from the source ss, assuming
its size is dynamic (so i cannot specify a range)?

 

[veek]

note to self: check time/date stamps before responding to threads ;-p