|
请参考:
Private Sub CommandButton1_Click() '打开
Application.ScreenUpdating = False
With Workbooks.Open(ThisWorkbook.Path & "\B.xls")
.Sheets(1).[b2] = [a1]
.Close True
End With
Application.ScreenUpdating = True
End Sub
Private Sub CommandButton2_Click() '不打开
Dim cnn As Object, rs As Object, strSql$
Set cnn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
cnn.Open "provider=microsoft.jet.oledb.4.0;extended properties='excel 8.0;hdr=no';data source=" & ThisWorkbook.Path & "\B.xls"
strSql = "update [Sheet1$b2:b2] set f1='" & [a1] & "'"
rs.Open strSql, cnn, 1, 3
cnn.Close
Set cnn = Nothing
End Sub
[ 本帖最后由 zhaogang1960 于 2010-1-1 21:58 编辑 ] |
|