Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dictionary - Add method parameters
I checked many posts about the Scripting.Dictionary and still cannot figure
out what the two parameters are, the key and a description or an item and a key or what? Then what is an item (or the description) and what can it be used for? If I have a description for each key, can I store it alongside the key and use it later after I found its corresponding key? My problem is as follows: I have a text file with 114000 lines. On each line, there is a contract number and a 3 character field (a code) that I must use to determine the template to use. Can I use the dictionary to solve my problem or not? The Add method is generally used in this manner: Dic.Add CStr(Item), Item or Dic.Add sh.Name, CStr(sh.Name) Could I use Dic.Add strContract, strCode If yes, then how do I search and display a specific contract number and its corresponding code? If no, should I use a Dictionary and a dynamic array instead? Thanks -- Jac Tremblay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please post this thread a correct full method, method about | New Users to Excel | |||
Please post this thread a complete correct method, method about te | New Users to Excel | |||
dictionary | Excel Programming | |||
Parameters for Find method | Excel Programming |