АТ
Александра Тершинова
помогите найти ошибку в VBA excel
Private Sub Combo2_Change()
cmd = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & ActiveWorkbook.Path & "\Laba5var13.mdb;Persist Security Info=False;"
Set cn = New ADODB.Connection
cn.ConnectionString = cmd
cn.Open
Set rs = New ADODB.Recordset
sql6 = "Select Cell from Отгрузки where izd= " & Combo2.Value & ";"
rs.Open sql6, cn
Lab7.Caption = rs.Fields(0)
rs.Close
cn.Close
End Sub