MSXML2.XMLHTTP

Question

Do you have a documentation for MSXML2.XMLHTTP in VBA?

Answer 1

Yes. MSXML2.XMLHTTP is part of Microsoft XML Core Services (MSXML), which is documented as part of the MSXML/XML platform and can be used from VBA via COM.

Key points from the available documentation context:

• MSXML is a set of services for working with XML documents: parsing, generating, validating, transforming, and transporting XML data.
• XMLHTTP is a component of MSXML designed to send and receive XML over HTTP.
• XMLHTTP is commonly used by applications (including VBA code) to retrieve or post XML data to web servers.

From the documentation:

• “MSXML is a set of services that provide functions for working with XML documents. A primary use of MSXML is to parse, generate, validate and transform XML documents so that the information can be displayed, stored, or manipulated.”
• “What is XMLHTTP? XMLHTTP is a component of MSXML. XMLHTTP is designed to pass XML documents to programs over the Internet using the standard Hyper-Text Transfer Protocol (HTTP). An example of a program using XMLHTTP is the Outlook Web Access Client, which uses XMLHTTP to retrieve e-mails from a mail server. Another common use is for posting XML data to a web server.”

For VBA in Office generally, the Visual Basic language reference and VBA object references are available and cover how to work with COM objects (such as MSXML2.XMLHTTP) from VBA code:

• The Visual Basic language reference documents the language syntax, data types, objects, and how to call COM components from VBA.
• The “Getting started with VBA in Office” content explains how to automate Office applications and call external components from VBA.

To use MSXML2.XMLHTTP from VBA in Excel or other Office apps, the typical pattern is:

1. Add a reference to the appropriate MSXML library (for example, via Tools → References in the VBA editor) or use late binding with CreateObject.
2. Create an instance of the XMLHTTP object.
3. Use its methods and properties (such as open, send, and response members) to perform HTTP requests and process XML or other responses.

The detailed member-by-member reference for MSXML2.XMLHTTP itself is part of the MSXML/XML documentation set, while the VBA documentation explains how to declare, create, and use such COM objects from VBA code.

---

References:

• Microsoft Security Bulletin MS10-051 - Critical
• Microsoft Security Bulletin MS02-008 - Critical
• Visual Basic language reference
• Getting started with VBA in Office