Home

Excel VBA web query fails

Highlighted
David L
Occasional 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"

 

Related Conversations
Help with excel
Alexvez01098 in Excel on
10 Replies
Rotate data from single cell to vertical listings
WEI_Bob in Excel on
2 Replies
2 Seniority Lists
Aminam20 in Excel on
6 Replies
Conditional formatting with wildcard
Rajeev_Raghavan in Excel on
2 Replies
Inconsistency error in the MROUND function
Fleischbender in Excel on
1 Replies