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.

Reading values from a closed workbook
 

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.

Reading values from a closed workbook
 

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.

Reading values from a closed workbook
 

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" 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.

Reading values from a closed workbook
 

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" 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.

Reading values from a closed workbook
 

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)?
--

thanks so much!
veek


"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" 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.

Reading values from a closed workbook
 

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

thanks so much!
veek


"veek" wrote:

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)?
--

thanks so much!
veek


"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" 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.