VBA 64 bits reading error

[Tofandel]

If I declare a dictionary from another module and use it in a function of another module then when trying to read a key using myDic("myKey") while in the debugger the keys are shown, the value returned is "Empty"

It works as expected on 32 bits version of excel but not on 64 bits

If I remove the dictionary module to use the default windows dictionary it works fine again

[Tofandel]

Related to VBA-tools/VBA-JSON#111

[dwjobling]

I'm also noticing this error with the dictionary only on 64 bit versions. The read seems to work ok the first time but fails on subsequent reads. This is also quite variable as to whether it fails or not - doesn't seem to be any discernible pattern. My temp fix is to read the value only once.

[LUIVLO]

Hi,

On 64 bits excel when i try to read a value like that LastName = Item("subscriber")("lastName")

I received a message : Automation Error

[Felix-N]

same problem here.

quick update:
the problem only occurs on accessing nested items - tested for 2 levels like Item("subscriber")("lastName")

Sometimes though it works. When it does not it works for now to assign a variable tmp to Item("subscriber") and then access from that variable tmp("lastName")

[nectorprime]

Allawys use 32 bit if you want your macros or VBA to work properly , the 64 bit is a problem , personally I stoped entertaining it anymore. I used to have problems with Ms Access 2016 , I had to switch back to 32 BIT because it even allows third party products to run side by side *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 22:47, Felix-N ***@***.***> wrote: same problem here. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#21?email_source=notifications&email_token=ALEEAHLYQPR3UQDTWFYW6KTQQ5FVBA5CNFSM4HGVALVKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOECOKZWY#issuecomment-547138779>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALEEAHMUMOF3R76CO3FX4DTQQ5FVBANCNFSM4HGVALVA> .