Reading values from a closed workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Brilliant! Many thanks Ron, I now have all the information, and alternatives
I need! Graham
 
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)?
 
Back
Top