Error on WebQuery

[UsmanBPD]

Hello all, recorded this code before:

Sub WebQuery()

    With ActiveSheet.QueryTables.Add(Connection:= _
        "URL;http://data.terapeak.com/?id=0&search=2&view=titles&query=my1stwish&date=2012-07-26&date_range=30&siteID=3" _
        , Destination:=Range("$F$5"))
        .Name = _
        "?id=0&search=2&view=titles&query=my1stwish&date=2012-07-26&date_range=30&siteID=3"
        .FieldNames = True
        .RowNumbers = False
        .FillAdjacentFormulas = False
        .PreserveFormatting = True
        .RefreshOnFileOpen = False
        .BackgroundQuery = True
        .RefreshStyle = xlInsertDeleteCells
        .SavePassword = True
        .SaveData = True
        .AdjustColumnWidth = True
        .RefreshPeriod = 0
        .WebSelectionType = xlAllTables
        .WebFormatting = xlWebFormattingNone
        .WebPreFormattedTextToColumns = True
        .WebConsecutiveDelimitersAsOne = True
        .WebSingleBlockTextImport = False
        .WebDisableDateRecognition = False
        .WebDisableRedirections = False
        .Refresh BackgroundQuery:=False
    End With
    ActiveWindow.SmallScroll Down:=36
End Sub

When run, it gives the error : "System Error&H80070057 (-2147024809). The Parameter is incorrect

Looking at the parameters I see no obvious error, any ideas?

[Fettertiger]

Hi Usman,

maybe the issue is caused by the website requesting a username and password

Regards

Theo