| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to refenence ranges on a closed workbook | Excel Discussion (Misc queries) | |||
| Force content in closed workbook | Excel Discussion (Misc queries) | |||
| Indirect( ) function loosing values when spreadsheets are closed | Excel Worksheet Functions | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
| Reading from a closed file. | Excel Worksheet Functions | |||
Linear Mode
