Excel VBA web query fails

Copper Contributor

With ActiveSheet.QueryTables.Add(Connection:= "URL;https://www.msn.com/en-us/money/stockdetails/fi-126.1.SFL.NYS?symbol=SFL&form=PRFIMQ", Destination:=Range("$A$1"))

 

Above fails to bring data into worksheet. Have used this for years.

 

"Unable to open ..." and the web address and " ..... Cannot download the information you requested"

 

1 Reply

I am having the same problem with multiple web queries that I have used for years.  They have long connection strings that are saved in .iqy files.  After I upgraded to Microsoft Office 365 they continued to work for a while but then later started throwing the "Cannot download the information you requested" error.  It has completely halted my work.  I prefer not to attempt a downgrade back to my old version of Excel.  The spreadsheets still work fine on another computer with the older version of Excel.  Is there a fix to this issue?  Is it a security setting?