Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using a VLOOKUP table to obtain data from another workbook called
DataWorkbook.xls, when both the workbook are open, all is OK , but I would prefer to read DataWorkbook.xls without opening it. In the ComboBox I use "ListFillRange" to identify the location of the workbook. I.E. 'C:\2004\Data\DataWorkbook.xls'!DataRange, the LinkedCell is defined as A1 which is used to place data in J1 and K1 Is there a way I can do this so that I can read the DataWorkbook.xls without opening it? -- Kind Regards Mick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
combobox | Excel Discussion (Misc queries) | |||
ComboBox | Excel Discussion (Misc queries) | |||
Populating combobox from another combobox | Excel Programming | |||
Combobox | Excel Programming |