Excel VBA web query fails

%3CLINGO-SUB%20id%3D%22lingo-sub-198671%22%20slang%3D%22en-US%22%3EExcel%20VBA%20web%20query%20fails%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-198671%22%20slang%3D%22en-US%22%3E%3CP%3EWith%20ActiveSheet.QueryTables.Add(Connection%3A%3D%20%22URL%3B%3CA%20href%3D%22https%3A%2F%2Fwww.msn.com%2Fen-us%2Fmoney%2Fstockdetails%2Ffi-126.1.SFL.NYS%3Fsymbol%3DSFL%26amp%3Bform%3DPRFIMQ%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.msn.com%2Fen-us%2Fmoney%2Fstockdetails%2Ffi-126.1.SFL.NYS%3Fsymbol%3DSFL%26amp%3Bform%3DPRFIMQ%3C%2FA%3E%22%2C%20Destination%3A%3DRange(%22%24A%241%22))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAbove%20fails%20to%20bring%20data%20into%20worksheet.%20Have%20used%20this%20for%20years.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22Unable%20to%20open%20...%22%20and%20the%20web%20address%20and%20%22%20.....%20Cannot%20download%20the%20information%20you%20requested%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-198671%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20%26amp%3B%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1277278%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20VBA%20web%20query%20fails%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1277278%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20the%20same%20problem%20with%20multiple%20web%20queries%20that%20I%20have%20used%20for%20years.%26nbsp%3B%20They%20have%20long%20connection%20strings%20that%20are%20saved%20in%20.iqy%20files.%26nbsp%3B%20After%20I%20upgraded%20to%20Microsoft%20Office%20365%20they%20continued%20to%20work%20for%20a%20while%20but%20then%20later%20started%20throwing%20the%20%22Cannot%20download%20the%20information%20you%20requested%22%20error.%26nbsp%3B%20It%20has%20completely%20halted%20my%20work.%26nbsp%3B%20I%20prefer%20not%20to%20attempt%20a%20downgrade%20back%20to%20my%20old%20version%20of%20Excel.%26nbsp%3B%20The%20spreadsheets%20still%20work%20fine%20on%20another%20computer%20with%20the%20older%20version%20of%20Excel.%26nbsp%3B%20Is%20there%20a%20fix%20to%20this%20issue%3F%26nbsp%3B%20Is%20it%20a%20security%20setting%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor

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
Highlighted

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?