Share via

Decoding JSON string

Anonymous
2019-09-04T16:01:48+00:00

To All,

I have a VBA Project (Excel Spreadsheet), that is reading JSON data from a website.

I have done this before in VB.NET and was able to create all of the Class declarations and Converters necessary to decode the JSON message (other application…other website).

Is there a way of doing this in VBA? I read other postings about 3rd party libraries, and I was even able to decode a simple JSON string using ScriptControl, but now I’m facing a JSON string with multiple records embedded in it (again, this was something that I could do in VB.NET), but I’m not sure how to translate the declarations (and layers of occurances of the data) into VBA.

I saw a link to the Excel Javascript API which has JSON references, but all I could see in that was “toJSON” references and not “fromJSON” or “JSONto” references.

Any suggestions or basic samples would be greatly appreciated.

Sincerely,

Paul Goldstein

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2019-09-04T18:16:59+00:00

    Hi Paul

    Greetings! I am Vijay, an Independent Advisor. I would suggest that you should make a post @ technet also so that you get support from expert from both the forums.

    Technet Excel Forum - https://social.technet.microsoft.com/Forums/off...

    Was this answer helpful?

    0 comments