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
Thanks
