https://www.ablebits.com/office-addins- ... cro-excel/scoobie wrote: ↑Sun May 03, 2020 8:19 pm
Many many thanks for the help. Where is the modules ?
you want to edit the code in the sheets and in the modules in the VBA editor
https://www.ablebits.com/office-addins- ... cro-excel/scoobie wrote: ↑Sun May 03, 2020 8:19 pm
Many many thanks for the help. Where is the modules ?
If you google "JSON to CSV converters" you should find what you need.Mark-H wrote: ↑Mon May 04, 2020 10:10 amI've taken a look at the VBA but can't for the life of me figure out how to import the data from the Betfair JSON file. I'm guessing that it will probably require processing the JSON using Python to the right layout and then pasting into the relevant data sheet. Am I on the right track?
Looks like a plan! I'll take a look, cheers.ShaunWhite wrote: ↑Mon May 04, 2020 2:28 pmIf you google "JSON to CSV converters" you should find what you need.
I hoped my reply didn't sound facetious. But hopefully knowing it's easiest to go via a CSV rather than directly from json to xls will help.... And that's covered pretty well generally and in far more detail than can be explained here. Good luck.Mark-H wrote: ↑Mon May 04, 2020 3:10 pmLooks like a plan! I'll take a look, cheers.ShaunWhite wrote: ↑Mon May 04, 2020 2:28 pmIf you google "JSON to CSV converters" you should find what you need.
Mark H.
Not at all. I took a look at what you suggested and you're right. There's also a ton of video tutorials on Youtube covering pretty much everything I was stuck on so with any luck it'll all become clearer as I go along. I just needed pointing in the right direction. Thanks.ShaunWhite wrote: ↑Mon May 04, 2020 6:10 pmI hoped my reply didn't sound facetious. But hopefully knowing it's easiest to go via a CSV rather than directly from json to xls will help.... And that's covered pretty well generally and in far more detail than can be explained here. Good luck.