Apply the following code to a module. or the workbook for a workbook open event.
Just having some fun!
Code:
Sub CtrlX()
Application.ScreenUpdating = False
WS = ActiveSheet.name
Sheets("Sheet3").Activate
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.mygoalmanager.com/goals/quoteRss.asp", Destination:=Range("A2"))
.name = "quoteRss": .FieldNames = True: .RowNumbers = False
.FillAdjacentFormulas = False: .PreserveFormatting = True
.RefreshOnFileOpen = False: .BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells: .SavePassword = False
.SaveData = True: .AdjustColumnWidth = True
.RefreshPeriod = 0: .WebSelectionType = xlAllTables
.WebFormatting = xlWebFormattingNone: .WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True: .WebSingleBlockTextImport = False
.WebDisableDateRecognition = False: .Refresh BackgroundQuery:=False
End With
Cells.Replace What:="document.write(", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
Cells.Replace What:="
*", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
Sheets(WS).Activate
Application.ScreenUpdating = True
MsgBox Sheets("Sheet3").Range("A2")
End Sub
Just having some fun!