你是大好人 把40分给我吧 Private Sub Command1_Click() Dim num As Integer Dim apl As New Word.Application apl.Documents.Open "d:\word\Doc1.doc" apl.Visible = False apl.Run "Project.NewMacros.test" apl.Documents.Close apl.Quit Dim cn As ADODB.Connection Set cn = New ADODB.Connection cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\word\db1.jsj;Persist Security Info=False" cn.Open Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset rs.Open "select * from a", cn, adOpenDynamic, adLockOptimistic, -1 rs.MoveFirst num = rs("num").Value rs.Update rs.Close cn.Close MsgBox num End Sub
把40分给我吧
Private Sub Command1_Click()
Dim num As Integer
Dim apl As New Word.Application
apl.Documents.Open "d:\word\Doc1.doc"
apl.Visible = False
apl.Run "Project.NewMacros.test"
apl.Documents.Close
apl.Quit
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\word\db1.jsj;Persist Security Info=False"
cn.Open
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Open "select * from a", cn, adOpenDynamic, adLockOptimistic, -1
rs.MoveFirst
num = rs("num").Value
rs.Update
rs.Close
cn.Close
MsgBox num
End Sub