Strange 'object invoked disconnected' then '1004 - object defined' errors

I have some VBA code that pulls stock quotations from Yahoo into Excel. The code has been running on Excel 2003 for years. Recently, I copied the application to a new desktop running W10, Office 2003, 2007 and 2013. It runs fine there under 2003. I also copied the application to a laptop running W10, Office 2003 and 2007. Most of the functions work on the laptop fine except the query that pulls data from Yahoo. The first time I run it, I get the '-2147417848 (80010108) automation error (object invoked disconnected' error. If I reset the macro and run again, I get the '1004 - Application - defined or object-defined error'. Thereafter, I can't even save or close the workbook. Excel hangs and has to be killed.

Here's some code:

Please Login or Register  to view this content.

The error occurs on the 'Refresh' command.

Thanks for any help or suggestions.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here