search

VBA-tools / VBA-JSON

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

Statement too complex error #222

Open HoLIMENt opened 2 years ago

HoLIMENt commented 2 years ago

Hi,

immediate upon import of the JsonConverter.bas file v2.3.1 into Visual Basic (v7.1 / 1116, part of MS Office 365 ProPlus x64), I receive the following error: "Statement too complex"

Could someone please help? From what I read this could be due to a a limit of "prolonging" lines with _ at the end, but with ~6K lines of code the cause isn't so easy to nail down. https://stackoverflow.com/questions/49411291/run-time-error-40046-statement-too-complex

Thanks and best!

karkados commented 2 years ago

Hi,

have you downloaded the code correctly? I first tried right click and save. This will create html code that is different from the .bas code. Try downloading the whole project as zip (top right corner, green "code" button). This way, I was able to import the code correctly into Word.

Best

HoLIMENt commented 2 years ago

Hi,

ah, indeed, that was the issue. Thanks a lot! There were some URL at the start of the .bas file, so I overlooked this strange saving behaviour.

Best!