• External Data Web Query – no longer working Excel 2010

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » External Data Web Query – no longer working Excel 2010


    It’s no mystery *why* my VBA will no longer get the web query data, the question is *how* to now get the data due to web page “upgrades”.

    I’m used to this, every 5 years or it’s been back to square 1 as far as this particular web query to HTML upgrades.
    The HTML and or the XML has been discontinued…we were forewarned.

    However, the web page in question still looks exactly the same as far as the data I used to obtain using at first Record Macro, then tweak the VBA code as I go, that’s how I learn’t to code, and this forum, very grateful.

    The web query will not work now as of today.

    Their “new” URL is


    It’s JSON, ( no reason given to upgrade their web site that makes sense, except to say it has put a spanner in the works of EVERYTHING I’ve learnt regarding VBA web query data import/s )
    What this page is about for my project is the daily times of events….then my VBA places all those times in time-order.
    If I can’t get that web query to work, the entire project does not work.

    What do I need to do to resume my project, starting at getting this same data onto my spreadsheet ? ( office 2010 on Win 7 Pro )

    I can provide samples of what it used to do after the Import,….and samples of the code that worked, yesterday.
    Now nothing works, as mentioned why.

    This may become an interesting endeavor to test things out of what’s new again regarding these perpetual IT upgrades


    Reply To: External Data Web Query – no longer working Excel 2010

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: