Empty .Items returns array of type Variant/String

[omegastripes]

Empty Scripting.Dictionary .Items returns empty array of type Variant/Variant in VBA, I use the array later to ReDim Preserve it and assign objects to it's elements.
Empty VBA-Dictionary .Items returns empty array of type Variant/String, it makes impossible to assign an object to it after ReDim.

[nectorprime]

Hi You do not need to redim anything here , just create a query (Recordset) and assign some dictionaries and collections depending to the structure of Json. *Managing Partner* *Ca Premier Accounting Package Developer - Zambia* *Nector Prime Accounting Solutions* *Findeco House 7th Floor Room 8* *Cairo Road* *Lusaka, Zambia* *Nector Prime Accounting Solution is a legally independent firm of Chartered Accountants and does not accept any responsibility or liability for the actions or inaction on the part of any other individual unaffiliated firm or firms.* P Please do not print this e-mail unless absolutely necessary. Save our ENVIRONMENT. This e-mail may contain privileged and confidential information. If you are not the intended recipient, you must not copy or distribute it. If you have received this e-mail in error, please notify the sender and delete the e-mail immediately. You should ensure that this e-mail and attachment is virus free. E-mail is not a 100% secure communication medium. We advise you understand this lack of security and take any necessary measures when emailing us. We reserve the right to read any email or attachment entering or leaving our systems from any source without prior notice. Information about Nector Prime Accounting Solutions can be found at our offices at Findeco House 7th Floor Room 8 or Call us on Cell No. +260977352401

…

On Mon, 28 Oct 2019 at 20:33, omegastripes ***@***.***> wrote: Empty Scripting.Dictionary returns empty array of type Variant/Variant in VBA, I use the array later to ReDim Preserve it and assign objects to it's elements. Empty VBA-Dictionary .Items returns empty array of type Variant/String, it makes impossible to assign an object to it after ReDim. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#26?email_source=notifications&email_token=ALEEAHPJT3FR6ACJG2VZLUDQQ4V55A5CNFSM4JF6IW62YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HU3EBOQ>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALEEAHIYS4LR6M5445KB5EDQQ4V55ANCNFSM4JF6IW6Q> .

[omegastripes]

Hi, thanks for the reply,

As I wrote I do use ReDim with simple array in my VBA code, it is quite enough for my application, and it works as it should. So I don't want to use Recordsets etc.

It works with no issues with Scripting.Dictionary. Now I tried VBA-Dictionary and found some difference, that is why I reported here.

[timhall]

Hi @omegastripes, thanks for raising this issue. The goal is as close to 100% compatibility as I can get, so it’s definitely appreciated. I’ll take a look and see what I can find