listbox with data coming from another workbook

G

Guest

Hello,

1. how to achieve to define a name of the xls file if there
are spaces 'like "this excel sheet.xls". And this seems to be refused by
Excel. How to solve this ?
ex:
Insert=>Name=>Define
Name: List1
RefersTo: =[Supplier List of Belgium.xls]Data!$A$1:$A$100


2. Can we imagine (in term of performance), having a list of 6000 items
coming from another workbook ?

Thanks for your valuable help.

Francois.
 
J

Jim Cone

Francois,

When I defined a name by selecting the refers to range,
Excel added single quotes marks before the first bracket and
before the exclamation point...
='[Do Not Respond.xls]Names'!$A$4:$C$4

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"François" <[email protected]>
wrote in message
Hello,
1. how to achieve to define a name of the xls file if there
are spaces 'like "this excel sheet.xls". And this seems to be refused by
Excel. How to solve this ?
ex:
Insert=>Name=>Define
Name: List1
RefersTo: =[Supplier List of Belgium.xls]Data!$A$1:$A$100

2. Can we imagine (in term of performance), having a list of 6000 items
coming from another workbook ?

Thanks for your valuable help.
Francois.
 

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

ADO retrieval from close workbook-data type issue 2
xlfTextRef from another workbook 1
Run code from another workbook 7
Copy to another workbook - prompt for input 3
Pulling data from one workbook to another one using VBA 0
HELP: How to call UDF defined in another workbook? 1
Open a workbook and get data from it 6
refresh data vba question 5

Top