1

How can I parse json data in Excel vba without using "Microsoft scripting runtime"? My company considers "Microsoft scripting runtime" to be a security risk so I can't use it.

I have been parsing JSON using vba string manipulation functions but that is painful.

Various answers in other questions suggest the VBA-JSON project, or ScriptControl, but they need "Microsoft scripting runtime". Sorry for using bold, but this question previously got closed, with a link to another question which recommends using "Microsoft scripting runtime".

rleir
  • 791
  • 1
  • 7
  • 19
  • It might be a bit easier to parse using Regular Expressions. Or perhaps you could use the [MAC dictionary project](https://github.com/VBA-tools/VBA-Dictionary) in place of scripting runtime. – Ron Rosenfeld Sep 26 '20 at 00:51
  • @RonRosenfeld thanks, the dictionary project is useful if I will be parsing JSON myself. – rleir Sep 26 '20 at 01:01
  • 1
    The VBA-JSON author has a drop-in Scripting.Dictionary replacement which also gives you Mac support https://github.com/VBA-tools/VBA-Dictionary. You don't need Scripting runtime in that case. – Tim Williams Sep 26 '20 at 04:08
  • @TimWilliams your comment should be an answer. thanks -- Rick – rleir Sep 28 '20 at 10:59

1 Answers1

1

The answer by ExcelHero (Daniel Ferry) at

Parsing JSON in Excel VBA and

https://medium.com/swlh/excel-vba-parse-json-easily-c2213f4d8e7a

is a big win compared to my string manipulation.

rleir
  • 791
  • 1
  • 7
  • 19