QueryTables.Add Not Working??

Help!
I have a couple different spreadsheets that have macros that pull stock pricing and other data from (two different) Google Sheets files. A few days ago, BOTH stopped working. Nothing in the files or the macro code was changed. They worked one day, and then quit working the next (and ever since). Here is the critical code section:

Please Login or Register  to view this content.

If I manually enter the URL into a browser, it downloads the CSV file just fine. But when the macro code runs, it pastes NOTHING into the destination (as if the Sheets file were completely empty).
If I manually download the CSV file, and manually paste the data into my Excel file, everything works fine.
But when I run the macro, I get no data (and therefore, the macro bombs out later on since it expects at least one row of data to exist). The actual code section above runs and does NOT produce any error; it just doesn't paste in any data.

What's going on? Is there another method I could use to download the file and paste the data into my Excel file, since apparently QueryTables.Add is not functioning properly?

I should note that I publish one of these files online, and I have heard from at least one other user that they are also getting the same problem now, so it not limited to my own PC.

No answers yet?

Is there any way (other than QueryTables.Add) to open a CSV file from a website using VBA? If I could simply open the file, I could then use VBA to manually copy and paste the data into my file. I don't need to maintain a data connection; I just need a copy of the current data. Any help would be GREATLY appreciated!