Hi,
I'm new to the forum, thanks for making this available.

I would like to pass a value from an Excel cell into the VBA ["'Start Period""] parameter. I've been trying to get this to work but have had no luck, any advice would be welcomed.


Code:
    With ActiveSheet.QueryTables.Add(Connection:= _
        "URL;http://sv73746:8088/v2_0/ReportService/keymetrics/etenSporXS6/?start_period=[""Start Period""]&end_period=[""End Period""]&format=html&suppress_error_codes=true" _
        , Destination:=Range("$A$1"))
        .Name = _
        "?start_period=[""Start Period""]&end_period=[""End Period""]&format=html&suppress_error_codes=true_1"
        .FieldNames = True
        .RowNumbers = False
        .FillAdjacentFormulas = False
        .PreserveFormatting = True
        .RefreshOnFileOpen = False
        .BackgroundQuery = True
        .RefreshStyle = xlInsertDeleteCells
        .SavePassword = False
        .SaveData = True
        .AdjustColumnWidth = True
        .RefreshPeriod = 0
        .WebSelectionType = xlEntirePage
        .WebFormatting = xlWebFormattingNone
        .WebPreFormattedTextToColumns = True
        .WebConsecutiveDelimitersAsOne = True
        .WebSingleBlockTextImport = False
        .WebDisableDateRecognition = False
        .WebDisableRedirections = False
        .Refresh BackgroundQuery:=False
    End With
Thanks Again!