Linked Questions

I just have this string: dim stringa as string stringa="{"data":{"GET:oauth.openapi.it\/counters":{"counter":22,"paid":0,"limit":false},"...

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 ...

Per example below...Looping through an object from a parsed JSON string returns an error "Object doesn't support this property or method". Could anyone advise how to make this work? Much appreciated ...

Is it possible to script JSON calls in a macro? I want to get a JSON string through an API connection. It looks like the problem is Excel expects the parameters to be passed in the HTML-string, but ...

I am trying to write some VBA code in Excel 2010 that would consume a web service. I am unable to find any related resources on the internet. Can someone please tell me how to do this.

I'm calling a web service in VB6 which returns a json string as response. I'm able to hold the response in a string. now I want to show the each parameter separately how can I extract the values from ...

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....

I am very new to VBA and I can not figure out how to get values from a Collection. This is my code: Dim p As Object Set p = JSON.parse(Response.Content) Dim links As Object Set links = p.Item("...

My client receives a spreadsheet with a number of columns, one being a "date". Only the date turns out to be formatted as Date(1292291582263-0700) (a JSON date it seems). I need to convert and work ...

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....

Is there any existing JSON parser which can be used from VB6? I could obviously write my own parser, but I don't want to reinvent the wheel if I don't have to. Thanks!

I'm trying to add an event to a Google Calendar using the Google API V3. I'm not using any of Google's libraries so I'm really baffled as to how to do this. Google's documentation tells me that I need ...

I have a number of local JSON files which I am trying to open as a string using VBA in order to extract specific information from them into Excel. I have seen a similar exercise work when the files ...

I am attempting to incrementally take a legacy application into current technologies. I have a C++ COM+ library using ADO on a server. A VB6 application is using the Recordset from a COM+ object ...

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....