Forum Discussion
Excel VBA web query fails
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 int...
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?