| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox with data coming from another workbook
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
listbox with data coming from another workbook
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" 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not all data coming through in Excel viewer | Excel Discussion (Misc queries) | |||
| Coming up with all possible combinations that add to a certain sumwithin a set of data | Excel Discussion (Misc queries) | |||
| Import Data with the filename coming from inputbox ? | Excel Programming | |||
| Use ListBox properties in This Workbook | Excel Programming | |||
| EXCEL VBA - Data compilation coming in from an external feed | Excel Programming | |||
Linear Mode
