When using VBA and Excel, I've found it easiest to just stick to XML for my REST calls and not try to deal with JSON. Talk about adding features to JSON to make it richer just makes me think everything goes around in circles.
What I'd like to see is an LLVM back-end that generates VBA, but I may never get around to it myself.