Results 1 to 12 of 12

transition from using IE to MSXML2.XMLHTTP"

Threaded View

  1. #6
    Forum Contributor
    Join Date
    05-17-2016
    Location
    Montreal
    MS-Off Ver
    2013
    Posts
    115

    Re: transition from using IE to MSXML2.XMLHTTP"

    If I run
    Sub GetStuff()
    Dim objXML As Object
    Dim strData As String
    Dim strResponse As String
    
     strData = "Request"
     Set objXML = CreateObject("MSXML2.XMLHTTP")
    
     objXML.Open "POST", "https://www.excelforum.com/excel-programming-vba-macros/" & strData, False
     objXML.Send
     strResponse = objXML.responsetext
    
    MsgBox strResponse
    
    End Sub
    I see a msgbox appear with all the html-body/tree inside.. I have XML, v3.0 & HTML Object Library references enabled..
    Is it possible all the html-content is not getting temporarily stored?
    IMAGE URL: https://imgur.com/a/3yAPbMR
    Last edited by Exequiel3k; 04-29-2019 at 10:44 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] WinHTTP (or XMLHTTP) bypas "the hostname in the certificate is invalid or doesn't match"
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-22-2018, 10:11 AM
  2. userform transition suddenly "flickering"
    By reploglejj in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-22-2015, 10:44 PM
  3. [SOLVED] Strange problem on web extract using MSXML2.XMLHTTP / WinHttp.WinHttpRequest.5.1
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2013, 05:13 AM
  4. CreateObject("MSXML2.XMLHTTP") put CCS tables into excel sheet ?
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2013, 07:35 PM
  5. How does the MSXML2.XMLHTTP object connect to the same session
    By paranidharan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2013, 04:38 PM
  6. XMLHTTP.ResponseBody / XMLHTTP.Responsetext Paste into Excel Sheet
    By gophins in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-11-2012, 11:38 AM
  7. MSXML2 - getElementsByTagName()
    By hoopz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2006, 03:41 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1