Help with ComboBox Please

  • Thread starter Thread starter Grandad
  • Start date Start date
G

Grandad

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?
 
Insert a sheet in the workbook containing the combobox and link cells in
that sheet to the closed workbook.

Use the cells in the inserted sheet for the ListFillrange
 
Thanks Tom much appreciated

Regards

Mick

Tom Ogilvy said:
Insert a sheet in the workbook containing the combobox and link cells in
that sheet to the closed workbook.

Use the cells in the inserted sheet for the ListFillrange
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

populate combobox from worksheet in different workbook 3
Can Listfillrange be used with a listbox or combobox on a form? 2
Rename combobox with a macro 1
Problem when Combo box has linked cell as a number 4
combobox change fires on workbook close when textcol <>1 or -1 2
Problem with ComboBox, dynamic range and change event 2
How to Set VB ComboBox ListFillRange to a Defined Range in an external workbook 1
combobox 2

Back
Top