User FAQs

1) What is the WinHttp Library ?
This is installed by default for Windows 11 and is actively supported.
This has no dependency on Internet Explorer.

2) What is the MSXML2 Library ?
This is an enormous library that contains a large number of objects and methods.
This is installed by default for Windows 11 and is actively supported.
This has a dependency on Interent Explorer.

3) What is the difference between "MSXML2.ServerXmlHttp" and "Winhttp.WinHttpRequest.5.1" ?
MSXML2.ServerXmlHttp has more functionality and provides basic built-in xml parsing / DOM
Winhttp.WinHttpRequest.5.1 has a slightly simpler API

CreateObject("MSXML2.ServerXmlHttp") 

4) What is the difference between "Winhttp.WinHttpRequest.5.1" and "MSXML2.XMLHTTP" ?
Winhttp.WinHttpRequest.5.1 has more functionality and is a dedicated http request library
MSXML2.XMLHTTP provides basic http functionality

CreateObject("Winhttp.WinHttpRequest.5.1") 

5) What is the difference between "MSXML2.XMLHTTP" and "Microsoft.XMLHTTP" ?
MSXML2.XMLHTTP was introduced in Excel 2010
Microsoft.XMLHTTP was used in Excel 97
You should always use MSXML2.XMLHTTP to use the latest version that is available.

CreateObject("MSXML2.XMLHTTP") 
CreateObject("Microsoft.XMLHTTP")