Reading values from a closed workbook

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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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


"Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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.
>
>

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

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Graham F" <[email protected]> wrote in message news:[email protected]...
> 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.

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

"Ron de Bruin" wrote:

> With code you can do this
> http://www.rondebruin.nl/copy7.htm
>
> Or
> http://www.rondebruin.nl/ado.htm
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Graham F" <[email protected]> wrote in message news:[email protected]...
> > 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.
>
>
>