How to write to memory or buffer JSON data of a parsed object via VBA-JSON?

Question

JSON

There is a VBA function that calls data from a parsed JSON object through a parameter into an excel sheet cell
Public http As Object, JSON As Object
Function GETJSON(key As String)
Set http = CreateObject("MSXML2.XMLHTTP")
http.Open "GET" , "%myurl%", False
http.Send
Set JSON = ParseJson(http.responseText)
GETJSON = JSON(key)
End Function
for parsing https://github.com/VBA-tools/VBA-JSON
Question: if possible save the data in a buffer or something like not loading the json object again, say, before closing the excel file

Answer 1

yes, save http.responseText to the cell Sheets(X).Cells(Y,Z), and when you need to get the data, do it
instead
Set JSON = ParseJson(http.responseText)