WSH, the "Windows Scripting Host", and therein the "SendKeys" method, programmatically simulating keystrokes.

All that is required is to have the data you want to grab on screen in a webpage. Then your program sends the keystrokes you would manually use to select, copy and paste into an Excel sheet

I don't know if even that would work with some of the sources I previously used.

My internet is a slow DSl (the downside of being in the mountains), so I can sometimes see how a web page is painted.
One of the sources (WSJ, I think) used to put all the data up in one go. Then they changed it and only the static text is painted at first. Then, probably by some java scripting, the data fields are populated. Slow enough on my connection that I can see the data values get painted one at a time. It takes 1-2 seconds for the page to stabilize.

The 99% of the rest of the world are on faster internet, 10 times faster than mine, so they wouldn't see it.

I suspect WSH and the like would have trouble with this.

I am aware of various methods of sending keystrokes, but didn't feel the work was worth the effort, so I gave up on the screen(s) that needed that data.