Linked Questions

I have the same issue as in Excel VBA: Parsed JSON Object Loop but cannot find any solution. My JSON has nested objects so suggested solution like VBJSON and vba-json do not work for me. I also fixed ...

I am trying to consume a web service in VB6. The service - which I control - currently can return a SOAP/XML message or JSON. I am having a really difficult time figuring out if VB6's SOAP type (...

I have a json like below: {"sentences":[{"trans":"something ru","orig":"english word","translit":"Angliyskoye slovo","src_translit":""}], "src":"en","server_time":69} and parse it: Function ...

I need to handle a JSON Object which is the response of XMLHTTPRequest in Excel VBA. I wrote the code below, but it doesn't work: Dim sc As Object Set sc = CreateObject("ScriptControl") sc....

I know a similar question has been asked and answered before a few times: Parsing JSON in Excel VBA, Excel VBA: Parsed JSON Object Loop However, the above solution doesn't work if I am trying to ...

I would like to use Microsoft ScriptControl to parse a JSON string in VBA, and then transform the resulting Object into Dictionary and Collection objects. I already know how to do the parsing with ...

if I want to write business logic into javascript files and test them from Excel VBA before handling them over to a web author then that requires being able to call javascript from VBA. From other ...

I'm trying to get a full detail list of Google places to an Excel sheet by using a Text Search request to Google. So I want to perform an API query (?) by writing a search string to an Excel cell ...

I am trying to build Excel page from iTunes query data. An example for Angry Birds app my query would look like: https://itunes.apple.com/lookup?id=343200656&country=AL checking Albania iTunes ...

I had tried the previous answer. Everything works fine until my data which extracted from server in the form of Json is giving me a key with multiple objects Excel VBA: Parsed JSON Object Loop ...

answering my own question here. I have done some work with JSON in Excel VBA and lots of findings to post which I will do so in Q & A format https://stackoverflow.com/help/self-answer https://blog....

In Excel VBA on Windows, how to mitigate problem of dot syntax traversal of parsed JSON broken by IDE's capitalisation behaviour? I have done some work with JSON in Excel VBA and lots of findings to ...

How do I access this key variable decoded from JSON? I used the example in Excel VBA: Parsed JSON Object Loop. VBA editor keeps changing the case to uppercase even when I change it to lowercase. I ...

Does Excel VBA provide any sort of method, function, or API for Punycode or converting to and from Unicode/Ascii for Internationalized Domain Names? I was able to find a JavaScript version (below) ...

I'm trying to loop through each item in the json file and get only few property values and put them in excel cells. Json file example- { "123": { "fname":"Testing", "lname":"Lname", ...