VBA-tools / VBA-Dictionary

Drop-in replacement for Scripting.Dictionary on Mac
MIT License
348 stars 89 forks source link

Run-time error '424' Object required #40

Closed cosmoc closed 9 months ago

cosmoc commented 9 months ago

Executing advanced example. Run-time error '424' Issue appears on

Dim Values As Variant ReDim Values(Parsed("values").Count, 3)

from the advanced example

The Spec.xlsx show all "pass"

Running Windows Microsoft® Excel® for Microsoft 365 MSO (Version 2302 Build 16.0.16130.20806) 64-bit

DecimalTurn commented 9 months ago

What is Parsed in this context? Did you try to add a breakpoint and check its value using the Locals Window?

cosmoc commented 9 months ago

I am single-stepping in debug

I created an example.json using the same data as the first example in the Readme.md I see this in the Watch Window.
image

DecimalTurn commented 9 months ago

Can you copy-paste the json content here?

Also, it looks like your question might belong in a different repo: https://github.com/VBA-tools/VBA-JSON

cosmoc commented 9 months ago

Oh - my error, Yes - this is for VBA-JSON. I obviously have too many tabs open at once. Should I close this and repeat in VBA-JSON?

The JSON is the same as in the simple example {"a":123,"b":[1,2,3,4],"c":{"d":456}}

cosmoc commented 9 months ago

Issue reported in the wrong repository. My apologies. Moving this report to VBA-JSON.

DecimalTurn commented 9 months ago

No worries, I've answered in the new issue. Feel free to close this one.