Linked Questions

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

I am parsing a JSON object in VBA. I found a code example on this forum that works great. However, one of the fields in the object is "total". in my code, I am trying to get the total, but "total" ...

My code to retrieve STRINGA: Private Sub RestExample() Dim APICall As String Dim Query As String Dim strKey As String, STRINGA AS STRING Dim myXML As New MSXML2.DOMDocument60 Dim ...

I'm trying to parse a simple JSON object. {"difficult:name and value with commas":"99,9%;100,00%","b":"very important value","date":"01/01/2023 ...

Is there a built-in way to URL encode a string in Excel VBA or do I need to hand roll this functionality?

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

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

What is the operator or function to test whether two variables of the same custom object type refer to the same object? I've tried If myObject = yourObject Then But get a runtime error 438 object ...

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 am trying to use the solution given to this, however, whenever I try to run the most basic anything, I get an Object not Defined error. I thought this would be my fault (not having installed ...

My company has a vendor providing a JSON feed of data that I need to load into our MS Access database every two hours. I need to: load the data from the feed, parse the JSON into a usable format for ...

I have the following json array which you can easily access at the below url: https://crowdfluttr.firebaseio.com/test/array.json It has the following output: {"-0p":{"date":"2015-01-01","string":"...

I have seen How can I send an HTTP POST request to a server from Excel using VBA? and the MacOS-friendly response that describes how to retrieve data from an HTTP endpoint using QueryTables. It ...

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

I have a macro that send an XMLHTTP request to a server and it gets as response a plain text string, not a JSON format string or other standard formats (at least for what I know). I would like to ...