View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Geof Wyght[_2_] Geof Wyght[_2_] is offline
external usenet poster
 
Posts: 38
Default 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


.