|
楼主 |
发表于 2013-3-11 13:40
|
显示全部楼层
已修改成功,谢谢楼上的热心帮助:Sub gongxusz()
Application.ScreenUpdating = False
Application.EnableEvents = False
Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Stpath = "123.mdb"
cnn.Open "Provider=Microsoft.Jet.Oledb.4.0;data Source=" & ThisWorkbook.Path & "\" & Stpath
cnn.Execute "Delete * from pl where 编号>='" & Sheet1.Range("b1").Value & "'and 编号<='" & Sheet1.Range("d1").Value & "'"
Sql = "select * from pl where 编号>='" & Sheet1.Range("b1").Value & "'and 编号<='" & Sheet1.Range("d1").Value & "'"
rst.Open Sql, cnn, adOpenKeyset, adLockOptimistic
A = Right(Sheet1.Range("B1"), 6)
B = Right(Sheet1.Range("D1"), 6)
For i = A To B
rst.AddNew
rst.Fields("编号") = Left(IIf(Sheet1.Range("B1").Value = "", Null, Sheet1.Range("B1").Value), 1) & Format(i, "0000000")
rst.Fields("单据名称") = Sheet1.Range("F1")
rst.Fields("数量") = Sheet1.Range("H1")
rst.Update
Next
Cells(3, 1).Select
Application.EnableEvents = True
Application.ScreenUpdating = True
End Sub |
|