Help with ComboBox Please
Grandad,
My educated guess is, no. Good luck.
Geof.
-----Original Message-----
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
.
|