The following may get you started.
Dim MDict As Dictionary
Dim SubDict1 As Dictionary
Dim SubDict2 As Dictionary
Set MDict = New Scripting.Dictionary
Set SubDict1 = New Scripting.Dictionary
Set SubDict2 = New Scripting.Dictionary
SubDict1.Add Key:="A", Item:=1
SubDict1.Add Key:="B", Item:=2
SubDict2.Add Key:="X", Item:=88
SubDict2.Add Key:="Y", Item:=99
MDict.Add Key:="SubDict1", Item:=SubDict1
MDict.Add Key:="SubDict2", Item:=SubDict2
MDict.Item("SubDict1").Add Key:="Nest1", Item:=3
MDict.Item("SubDict1").Add Key:="Nest2", Item:=4
Debug.Print MDict.Item("SubDict2").Item("X")
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
wrote in message
ups.com...
Hi,
fairly straight forward one here.
Can I create a nested Dictionary structure, that is, store and retrieve
Objects of type Dictionary within another Object of type Dictionary??
Also, I would be greatfull if someone could tell me where on MSDN i can
find this sort of information. All I am able to find is overly simple
examples using primitive data types, what I am looking for is a full
API documentation similar to that which Sun provide for the Java
programming language.
Many thanks in advance!
Alan