Vba post request json

'https://github.com/VBA-tools/VBA-Web. 
'Using this library, it would look like:

Sub sendPostRequest()
  Dim Body As New Dictionary
  Dim Client As New WebClient
  Dim Response As WebResponse

  Body.Add "mType", "OPEN_SYSTEM_TRADE"
  Body.Add "systemOwnerId", 10
  'Equal to Body = "{""mType"":""OPEN_SYSTEM_TRADE"",""systemOwnerId"":10}"

  Set Response = Client.PostJson("somewebsite.com", Body)

  Worksheets("Sheet1").Range("A1").Value = Response.Content
End Sub

Source: stackoverflow.com

Similar codes

1 vote338 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
1 vote295 views1 answer
How to do error handling in access vba
VBA
0 vote306 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote292 views1 answer
Find the name of the last excel sheet vb
VBA
2 votes325 views1 answer
Vba file from path
VBA
1 vote292 views1 answer
Close form vba
VBA
1 vote308 views1 answer
Excel format cell as kilowatts
VBA
1 vote307 views1 answer
Excel vba first row in range
VBA
1 vote322 views1 answer
Export datagridview to excel vb.net
VBA
0 vote332 views3 answers
Write to text file vb.net
VBA