Greetings
I am trying to extract data from SQL Server using Excel VBA.
Below is the code which errors out @ the Rs.Open StrSQL, Con
Sub DbConnection()
Dim Con As ADODB.Connection
Dim Rs As ADODB.Recordset
Dim Fld As ADODB.Field
Dim StrSQL As String
Dim Wb As ThisWorkbook
Dim Ws As Worksheet...