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]
Excel ODBC DSN-less Connection 19. February 2013 sellout Excel (0) Create an Excel workbook with DSN-less Data Connection that works with parameterized stored procedures that take values from cells. [More]