I have a macro in Excel 2007 that gets some data from the web (shown below). I sent it to someone using Excel 2003 but the macro does not run. What was the OLD way for the following code snippet?
Thanks!
Thanks!
Code:
symbol_string = "URL;http://www.marketwatch.com/tools/quotes/options1.asp?source=&symb=" & ticker & "&time=&bars=1&bars=2&bars=3&bars=4&bars=5&bars=6&bars=7&bars=8&bars=9&bars=10&bars=11"
With ActiveWorkbook.Connections("MarketWatchOptionData")
.Name = "MarketWatchOptionData"
.Description = "Get Options data from MarketWatch"
End With
With Selection.QueryTable
.Connection = symbol_string
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = "1"
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
.RefreshStyle = xlOverwriteCells
.AdjustColumnWidth = False
End With
Last edited by a moderator: