none
Excel VBA - You’ll need a new app to open this about RRS feed

  • Question

  • I received a Windows 10 1803 update a few months ago, since then I keep received the following message "You’ll need a new app to open this about" whenever sending a request using MSXML2.XMLHTTP60  in Excel 2010 or Excel 2016 (on different computers) to the site https://www.asx.com.au/asx/statistics/indexInfo.do.

    I access many other site with the same code with different URL and have no problems.

     

    I have upgrade to Windows 10 1809, still the issue remains.

    Any help would be appreciated.

    Code that will generate error

    ''* Tools->References: Microsoft xml, v6.0

    Private XMLPage As New MSXML2.XMLHTTP60

    ''* Tools->References: Microsoft  HTML Object  Library

    Private HTMLDoc As New MSHTML.HTMLDocument

    Sub TestXML()

       URL = "https://www.asx.com.au/asx/statistics/indexInfo.do"

        With XMLPage

            .Open "GET", URL, False

            .send

            HTMLDoc.body.innerHTML = .responseText

        End With

    End Sub




    Friday, December 14, 2018 1:48 AM

Answers

  • Hi flaxman,

    Thanks for visiting our forum.

    Then here we mainly focus on general issues about Excel desktop client. Since your query is related to VBA, I'll move your thread to the dedicated MSDN forum for Excel for better response:

    https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=exceldev

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    Regards,

    Yuki Sun


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    • Marked as answer by flaxman Friday, December 14, 2018 6:43 PM
    Friday, December 14, 2018 7:34 AM