[VBA] 1-msscriptcontrol 2-json

Although VBA is a dynamic type language, the lack of programming mechanisms and basic library is still quite difficult.

Recently I found a good thing to use scriptcontrol.(Not ASP. NET, and there are not many documents)The explosive power is good!

 

Excel uses JavaScript and VBScript in VBA (1)

Excel uses JavaScript and VBScript in VBA (2)

Excel uses JavaScript and VBScript in VBA (3)

 

Another bonus: XMLHTTP can also be used. In addition, the JSON parser of VB [local download].

 

In summary, we have an HTTP request, a responsexml, and a JSON parsing method, so we can use it freely ~