search

VBA-tools / VBA-JSON

JSON conversion and parsing for VBA
MIT License
1.76k stars 568 forks source link

Compile Error: A module is not a valid type #198

Closed danfelt closed 3 years ago

danfelt commented 3 years ago

I've imported VBA-JSON-2.3.1 into Excel 2016 (64-bit) and when I compile my code, I get " Compile Error: A module is not a valid type " on the following line of code: " Private Function json_ParseObject(json_String As String, ByRef json_Index As Long) As Dictionary "

I've added References to Microsoft Scripting Runtime and Microsoft Forms 2.0 Object Library. Any help, solutions or suggestions would be greatly appreciated!

RayCulp commented 3 years ago

I suspect that you have a module in the project called "Dictionary" in addition to the Dictionary class from Microsoft Scripting Runtime. If this is the case, you might try deleting or renaming the module.

danfelt commented 3 years ago

Thank you @RayCulp, that solved my issue!