0

I'm struggling to find any resources on how to successfully format this data accordingly. enter image description here

I have the json string, but at this point I can only insert it into a message box, and I have not in the slightest clue how to move forward.

I've seen people do something like this, but I would appreciate some guidance to get to that point. Thanks in advance.


ws.Cells(1, 1) = "Induct"
ws.Cells(1, 2) = "Rebin"
ws.Cells(1, 3) = "Pack"

For Each item In jsonObject
    ws.Cells(i, 1) = item("Induct")
    ws.Cells(i, 2) = item("Rebin")
       ws.Cells(i, 3) = item("Pack")
    i = i + 1
Next```
Improve this question
6
  • 1
    Please edit your question to show the actual JSON - it's easier to parse than the screenshot you have there. Basic approach would be to use the VBA-JSON library (github.com/VBA-tools/VBA-JSON) to parse the json, then follow the same sort of steps you show in your code. Plenty of examples here: if you run into a specific problem then update your code and add an explanation of the problem you're having. Commented May 3, 2022 at 21:07
  • There's no such thing as an Excel string. Commented May 3, 2022 at 21:57
  • 1
    Eg: see stackoverflow.com/questions/61999980/… or google.com/… Commented May 3, 2022 at 22:35
  • @JoelCoehoorn I'm sorry? lol Commented May 3, 2022 at 22:41
  • @JoelCoehoorn Oh I see lol, I just needed to add words to my question because of "Similar Questions have been asked." I guess I just kinda blurbed something out Commented May 3, 2022 at 22:42
Related questions
0
VBA: Creating substrings out of JSON and reformatting into columns
1
How to split json into single json strings using VBA?
1
how to display my JSON object in good format in VBA Excel
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.