I'm working on calling a web service through a macro. The actual call seems to work OK. Now I'm stuck as to how best to parse the response, which is in JSON.
I've done some searching and come across a couple of approaches for doing this in VBA (Excel):
What I'm not understanding is how best to use either of these from within an ER/Studio macro. Any tips or pointers? Do I load these as "modules?" Do I use a #Uses comment? Something else? My tinkering has generated only syntax errors and frustration, so looking for any tips and pointers anyone might have about incorporating VBA modules in an ER/Studio macro.