Petrichor
  • Member for 4 years
  • Last seen more than a month ago
  • Reading, United Kingdom
Stats
498
reputation
19k
reached
7
answers
10
questions
Loading…
About

MEng, PhD candidate. A bit of experience in C++, Fortran 77 and now VBA via excel.

Saving for a later project, scraping and analysing data for fantasy football:

 Public Sub exceljson()
Dim https As Object, Json As Object, i As Integer

Dim Item As Variant

Set https = CreateObject("MSXML2.XMLHTTP")
https.Open "GET", "https://min-api.cryptocompare.com/data/price?fsym=USD&tsyms=BTC", False
https.Send

Set Json = JsonConverter.ParseJson(https.responseText)

i = 2
For Each Item In Json.Items
    Sheets(1).Cells(i, 2).Value = Item
    i = i + 1
Next
MsgBox ("complete")
End Sub
This user doesn’t have any gold badges yet.
6
silver badges
20
bronze badges
3
Score
8
Posts
47
Posts %
3
Score
6
Posts
35
Posts %
3
Score
6
Posts
35
Posts %
3
Score
4
Posts
24
Posts %
3
Score
3
Posts
18
Posts %
3
Score
2
Posts
12
Posts %
Top posts
View all questions and answers