|
我把你的合同编号输入的地方改到B1了
Sub test()
Dim SQL$, SQL_2$
Sheets("Sheet2").[A4:F1000].ClearContents
Set cnn = CreateObject("ADODB.Connection")
Set cnn_2 = CreateObject("ADODB.Connection")
cnn.Open "provider=microsoft.jet.oledb.4.0;extended properties=excel 8.0;data source=" & ThisWorkbook.FullName
cnn_2.Open "provider=microsoft.jet.oledb.4.0;extended properties=excel 8.0;data source=" & ThisWorkbook.FullName
SQL = "Select 借款日期,到期日期,借款金额,还款日期,还款金额,借款金额 from [Sheet1$] where 合同编号 ='" & ActiveSheet.Cells(1, 2) & "'"
SQL_2 = "Select first(客户姓名) from [sheet1$] where 合同编号 ='" & ActiveSheet.Cells(1, 2) & "'"
Sheets("Sheet2").[A4].CopyFromRecordset cnn.Execute(SQL)
Sheets("Sheet2").[b2].CopyFromRecordset cnn_2.Execute(SQL_2)
cnn.Close
cnn_2.Close
Set cnn = Nothing
Set cnn_2 = Nothing
End Sub
|
|