Message 1 of 6
Dictionary Object

Not applicable
01-15-2001
11:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
I am trying to create a Dictionary object in VBA to store user defined data.
I tried the following example from the Help file but the code doesn't work.
Dim d 'Create a variable
Set d = CreateObject(Scripting.Dictionary)
d.Add "a", "Athens" 'Add some keys and items
d.Add "b", "Belgrade"
d.Add "c", "Cairo"
VBA doesn't recognise Scripting.Dictionary as a defined
variable.
Will someone tell me the proper way to define a Dictionary
object.
TIA
--
Gene Redmon
Corporate CADD Manager
Hunsaker and Associates Irvine, Inc.
I tried the following example from the Help file but the code doesn't work.
Dim d 'Create a variable
Set d = CreateObject(Scripting.Dictionary)
d.Add "a", "Athens" 'Add some keys and items
d.Add "b", "Belgrade"
d.Add "c", "Cairo"
VBA doesn't recognise Scripting.Dictionary as a defined
variable.
Will someone tell me the proper way to define a Dictionary
object.
TIA
--
Gene Redmon
Corporate CADD Manager
Hunsaker and Associates Irvine, Inc.