Sub Get_Data_from_SQL()
Dim sPath As String, strSQL As String, objCon As Object, objRS As Object
sPath = ThisWorkbook.FullName
Set objCon = CreateObject("ADODB.Connection")
objCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & sPath & ";" & _
"Extended Properties=""Excel 8.0;HDR=No"";"
'tab - именованный диапазон откуда берутся данные
strSQL = "SELECT tab.[F1] as [Контрагенты], tab.[F2] as [DD1], tab.[F3] as [DD2] FROM tab WHERE tab.
[F2]>0 "
' или так:
' strSQL = "SELECT [A2:C15].[F1] as [Контрагенты], [A2:C15].[F2] as [DD1], [A2:C15].[F3] as [DD2] FROM [A2:C15] WHERE [A2:C15].[F3]>0 "
Set objRS = objCon.Execute(strSQL)
Range("A20").CopyFromRecordset objRS
objCon.Close: Set objCon = Nothing
End Sub