Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading a named range
We have built a summary workbook which depends heavly on Excel's ability to read data from named cells in dozens of other workbooks. The VBA code looks similar to this: C.Range(FreeCFYieldCol & R).Formula = "='w:\" & Wb & ".xls'!iFCFYLD" The problem is performance. Each workbook has maybe a dozen named cells which are to be read by the summary workbook. These workbooks sit on a network. I'm assuming that each workbook file is opened and closed every time a named cell's value is read. Question, is there a method my which we can code the summary workbook so that it retrieves the values of all 12 named cells (probably storing those values in variables) so that the workbooks are opened and closed but once? TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading a named range
Am I missing something? How does one retrieve data from multiple range names
this way? Otherwise, the workbook is opened and closed for each range name, isn't it? "Pierre Archambault" wrote in message . .. Try putting a formula that retreives the data directly from the cells you need. ='[Other workbook.xls]'!RangeName (Single quotes and braces if spaces in workbook's name) or =OtherWorkbook.xls!RangeName Use the full path if not the same as the current Workbook "Karl Thompson" a écrit dans le message de ... We have built a summary workbook which depends heavly on Excel's ability to read data from named cells in dozens of other workbooks. The VBA code looks similar to this: C.Range(FreeCFYieldCol & R).Formula = "='w:\" & Wb & ".xls'!iFCFYLD" The problem is performance. Each workbook has maybe a dozen named cells which are to be read by the summary workbook. These workbooks sit on a network. I'm assuming that each workbook file is opened and closed every time a named cell's value is read. Question, is there a method my which we can code the summary workbook so that it retrieves the values of all 12 named cells (probably storing those values in variables) so that the workbooks are opened and closed but once? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List Box - For Input Range can I use named range in another workbo | Excel Worksheet Functions | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) |