Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Cell Contents to Reference External Workbooks
Hello:
I have several workbooks named NODE1, NODE2, NODE3, ETC. These workbooks are generated individually and automatically by another program. Approximately 1300 files will automatically get generated and updated on a regular basis. These workbooks have 2 columns each, MATERIAL and QUANTITY. The MATERIAL column is static and the same in all workbooks, but the QUANTITY column will change in each workbook. I want to have a master workbook named BOM that has the same MATERIAL column and a separate QUANTITY column for each NODE workbook. If I name the columns in the BOM workbook, MATERIAL, NODE1, NODE2, NODE3, etc how can I use the column name to reference the external workbook of the same name? I have tried INDIRECT, but it doesn't seem to allow me to use file paths as part of the formula. Any advice? "Pigs can't be humans, but humans can be Pigs!" Eating at the trough of life. Oink! SowBelly |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Cell Contents to Reference External Workbooks
Hi
INDIRECT works only with open workbooks See the following thread for accessing closed workbooks (in your example INDIRECT.EXT from the add-in morefunc.xll maywork): http://tinyurl.com/2c62u -- Regards Frank Kabel Frankfurt, Germany SowBelly wrote: Hello: I have several workbooks named NODE1, NODE2, NODE3, ETC. These workbooks are generated individually and automatically by another program. Approximately 1300 files will automatically get generated and updated on a regular basis. These workbooks have 2 columns each, MATERIAL and QUANTITY. The MATERIAL column is static and the same in all workbooks, but the QUANTITY column will change in each workbook. I want to have a master workbook named BOM that has the same MATERIAL column and a separate QUANTITY column for each NODE workbook. If I name the columns in the BOM workbook, MATERIAL, NODE1, NODE2, NODE3, etc how can I use the column name to reference the external workbook of the same name? I have tried INDIRECT, but it doesn't seem to allow me to use file paths as part of the formula. Any advice? "Pigs can't be humans, but humans can be Pigs!" Eating at the trough of life. Oink! SowBelly |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Cell Contents to Reference External Workbooks
Frank: Thanks for the pointer. SowBelly On Wed, 28 Jul 2004 06:58:12 +0200, "Frank Kabel" wrote: Hi INDIRECT works only with open workbooks See the following thread for accessing closed workbooks (in your example INDIRECT.EXT from the add-in morefunc.xll maywork): http://tinyurl.com/2c62u |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference to cell with external spreadsheet | Excel Worksheet Functions | |||
Using cell value to build external reference | Excel Discussion (Misc queries) | |||
cell data for external reference | Excel Worksheet Functions | |||
Using cell value to reference external worksheet? | Excel Worksheet Functions | |||
Pass cell contents to external program as commandline option | Excel Discussion (Misc queries) |