search

VBA-tools / VBA-Web

VBA-Web: Connect VBA, Excel, Access, and Office for Windows and Mac to web services and the web
http://vba-tools.github.io/VBA-Web/
MIT License
2.01k stars 494 forks source link

Office365 click to run edition build 1804+ hangs when using WebHelpers.ParseJson on long strings. It takes several seconds as opposed to milliseconds to parse simple json #349

Closed joajitsu closed 6 years ago

joajitsu commented 6 years ago

WebHelpers.ParseJson hangs excel on Office365 click to run Excel version 1804 and above. On any other Excel version it works fine On office 365 build 1803 it works fine.

Parsing large json results will cause excel to hang. The parsing takes a fraction of a second on any other Excel build.

Tested it on different Office versions. The method works fine when downgrading to build 1803.

Not sure if this is an issue with microsoft or native to the VBA.

zgrose commented 6 years ago

Grab the latest cut that has the VBA-JSON v 2.3.0 bits in it. Likely duplicate of #341 and #345

joajitsu commented 6 years ago

You are a life saver!!! Thanks a million. That worked. I had the code from 2 weeks ago and looks like the latest build from last week did the trick.