Did You Need an Excel Data Connection with Parameters - One with Multi-Values? 4. September 2013 sellout Excel (0) Const ValueSheetName As String = "MyParamSheet" Const ServerName As String = "ServerName" Public Sub GetData() ThisWorkbook.Names("Results").RefersToRange.Value = "Getting..." Dim oWorksheet As Worksheet On Error Resume Next Set oWorksheet = ThisWorkbook.Worksheets(ValueSheetName) On E... [More]