listbox with data coming from another workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

François - 21 Mar 2006 22:00 GMT

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.

Reply to this Message

Jim Cone - 22 Mar 2006 02:27 GMT

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" <Franois@discussions.microsoft.com>
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.

Reply to this Message