浅谈xmlhttp对象(属性和方法)-vba抓取网页数据（The xmlhttp object (attribute and method) -vba crawling the web data）.docVIP

浅谈xmlhttp对象(属性和方法)-vba抓取网页数据（The xmlhttp object (attribute and method) -vba crawling the web data） [originality] on XMLHTTP objects (attributes and methods) -VBA grab web data There are many ways to grab web data with VBA, one of which is to refer to XMLHTTP objects. Here we try to introduce some of the basic properties and methods of this object, and some examples of applications. XMLHTTP object reference IXMLHTTPRequest Provides a protocol for client to communicate with HTTP server Sample The following example establishes a XMLHTTP object and sends a request to the HTTP server to request the return of the XML source file (XML document). If the server fails to connect, then the error is returned. Dim HttpReq As Object Set HttpReq = CreateObject (MSXML2.XMLHTTP.3.0) HttpReq.open GET, http:// ajaxServer.aspx, False HttpReq.send MsgBox HttpReq.responseText Explanation: the first, second line can be replaced by the following statement, but the premise is to refer to Microsoft XML, v2.6-6.0 (msxml2.dll, msxml3.dll, msxml4.dll, msxml5.dll, msxml6.dll) in the object first. Dim HttpReq As New MSXML2.XMLHTTP30 Remarks The client can send requests to the HTTP server via the XmlHttp object (MSXML2.XMLHTTP.3.0) and use the Microsoft XML document object model Microsoft XML Document Object Model (DOM) to process the response. The pair integrates the Microsoft XML Core Services (MSXML), supports direct sending request, and analyzes the response with MSXML DOM. Due to the integration of Extensible Stylesheet Language (XSL) support, XMLHTT object component provides a very simple way to send to the HTTP server to a structured query, and support the use of various forms of effective display results. The usual order of use is to use the open method first, then send the request with the send method, and then use the setRequestHeader method to set the custom header information, and finally see four kinds of response results returned in different forms. XMLHTTP objects support Microsoft