Parse JSON into Array in VBA

[.René Teinze]

Hello.

Is it possible to get an array from a JSON-String to use in VBA? Like in PHP or Javascript.

I don't need it in Excel but I need to use the data in VBA.

Thanks a lot.

René

[Bruce McPherson]

Yes.. What does your data look like and what do you want to do with it ?

Sent from my iPad

--
You received this message because you are subscribed to the Google Groups "Excel Liberation" group.
To unsubscribe from this group and stop receiving emails from it, send an email to excel-ramblin...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[ech...@gmail.com]

I have been looking for this answer for long time and since I'm not a programmer and http://www.mcpher.com is so hard to read, lots of hyperlinks on every sentence I have no clue where to go. Hopefully someone can give example to let me to follow.

This is the link data I'm interested in:

http://stock.finance.sina.com.cn/usstock/api/json.php/US_MinKService.getMinK?symbol=msft&type=15&___qn=3

Thanks,

[Bruce Mcpherson]

This site is really for VBA developers, although implementing something like this is rather straightforward.

your proc is 

Public Sub testSina()

    generalQuery("sina", "sina", _

        InputBox("Enter stock symbol")).tearDown

End Sub

your library entry is

        With .add("sina")

            .add "restType", erRestType.erSingleQuery

            .add "url", "http://stock.finance.sina.com.cn/usstock/api/json.php/US_MinKService.getMinK?type=15&___qn=3&symbol="

            .add "results", ""

            .add "treeSearch", True

            .add "ignore", vbNullString

        End With

If you download the latest cdataset.xlsm, you'll find it implemented in the last tab (called sina)

bruce

--