associative arrays

[kalle]

Hi

Is it possible to use Associative arrays in vba?

If possible, I would be glad if someone could show me how.

Thanks in advance

*** Sent via Developersdex http://www.developersdex.com ***

 

[Steve Yandl]

kalle,

Take a look at the "Scripting.Dictionary" object.
http://msdn.microsoft.com/en-us/library/x4k5wbx4(VS.85).aspx
Most of the examples you will find are for vbScript but that all works fine
in VBA.


Steve Yandl

 

[Matthew Herbert]

Hi

Is it possible to use Associative arrays in vba?

If possible, I would be glad if someone could show me how.

Thanks in advance

*** Sent via Developersdexhttp://www.developersdex.com***

Kalle,

I can't say that I'm familiar with "associative arrays" (but this may
simply be a diction issue); however, a quick Internet scan leads me to
beleive that each element has a value and a key. If this is the case,
then look into using a Collection or Dictionary object. (For a
collection, this is assuming that you will know what the key is
though. Also, a Collection won't let you add a duplicate key).

There are some good discussion points in the following thread:
http://groups.google.com/group/micr...1f6?lnk=gst&q=collection+key#2a4688dd147e61f6

Best,

Matthew Herbert