Help with "Lookup" Please

[Grandad]

Hi

I am using a VLOOKUP table to obtain data from another workbook. All is OK
when the workbook is open, but I would prefer to read the date without
opening the workbook.

Is there a way to do this?

 

[Grandad]

Sorry I forgot to mention that this is controlled from a ComboBox
Regards

 

[Dave Peterson]

=vlookup() will work with a closed workbook.

What's the problem you're having?

And you may want to post the formula that's causing trouble.

(If you use =indirect() within the =vlookup(), then that's where the problem
is.)

Harlan Grove wrote a UDF that allows you to retrieve values from a closed
workbook when you build that string that points at the
drive/folder/filename/sheetname/range address.

http://www.google.com/[email protected]

 

[Grandad]

Dave

I don't think I have explained myself very well.

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

Regards

Mick

 

[Dave Peterson]

Maybe you could use another worksheet (hidden???) with a formula that retrieves
the values from that range and uses that as the listfillrange.

Dave

I don't think I have explained myself very well.

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

Regards

Mick