|
楼主 |
发表于 2020-10-17 22:29
|
显示全部楼层
老师:
' If Not d(arr1(i, 2)).Exists(arr2(j)) Then
Set d(arr1(i, 2))(arr2(j)) = CreateObject("scripting.dictionary") '二级字典嵌套
' End If
d(arr1(i, 2))(arr2(j)) 的关键字是arr2(j),建筑工程、安装工程,测试出错,暂注释掉了
For i = 1 To UBound(arr1, 1)
If Not d.Exists(arr1(i, 2)) Then
Set d(arr1(i, 2)) = CreateObject("scripting.dictionary") '一级字典嵌套
End If
For j = 0 To UBound(arr2)
If Not d(arr1(i, 2)).Exists(arr2(j)) Then
Set d(arr1(i, 2))(arr2(j)) = CreateObject("scripting.dictionary") '二级字典嵌套
End If
Next
Next
'给嵌套字典赋值
For i = 1 To UBound(arr1, 1)
For j = 0 To UBound(arr2)
If arr1(i, 2 + j + 1) <> "" Then
d(arr1(i, 2))(arr2(j)) = d(arr1(i, 2))(arr2(j)) + arr1(i, 2 + j + 1) ‘此名仍显示运行错误
Debug.Print d(arr1(i, 2))(arr2(j))
End If
Next
请老师指点
Next |
|