给段写EXCEL的代码参考:Option Explicit Dim xlapp As Variant Dim xlBook As Variant Dim xlSheet As VariantPrivate Sub Command1_Click() Set xlapp = CreateObject("excel.application") xlapp.Visible = True Set xlBook = xlapp.Workbooks.Add Set xlSheet = xlBook.worksheets(1) xlSheet.Cells(1, 1) = Date$ xlSheet.Cells(1, 2) = Time$ xlSheet.Cells(1, 3) = "123" xlSheet.Cells(1, 4) = "ABC" End Sub
Dim xlapp As Excel.Application Dim xlbook As Excel.Workbook Dim xlsheet As Excel.Worksheet Set xlapp = CreateObject("excel.application") Set xlbook = Workbooks.Open("d:\data\job.xls") Set xlsheet = xlbook.Worksheets(1)
End With xlbook.Save xlbook.Close xlapp.Quit Set xlapp = Nothing
End Sub就是不知道怎么把第二条记录中字段id的值赋给b1.
Dim xlapp As Excel.Application Dim xlbook As Excel.Workbook Dim xlsheet As Excel.Worksheet Set xlapp = CreateObject("excel.application") Set xlbook = Workbooks.Open("d:\data\job.xls") Set xlsheet = xlbook.Worksheets(1)
End With xlbook.Save xlbook.Close xlapp.Quit Set xlapp = Nothing
End Sub
Dim xlapp As Excel.Application Dim xlbook As Excel.Workbook Dim xlsheet As Excel.Worksheet Set xlapp = CreateObject("excel.application") Set xlbook = Workbooks.Open("d:\data\job.xls") Set xlsheet = xlbook.Worksheets(1)
End With '这两条没用上 xlbook.Save xlbook.Close xlapp.Quit Set xlapp = Nothing
End Sub
Dim xlapp As Excel.Application Dim xlbook As Excel.Workbook Dim xlsheet As Excel.Worksheet Set xlapp = CreateObject("excel.application") Set xlbook = Workbooks.Open("d:\data\job.xls") Set xlsheet = xlbook.Worksheets(1)
with Adodc1.Recordset .movefirst while not .eof i=i+1 xlsheet.Range("a" & i) = .Fields("id") .movenext wend end with xlbook.Save xlbook.Close xlapp.Quit Set xlapp = Nothing
Dim xlapp As Variant
Dim xlBook As Variant
Dim xlSheet As VariantPrivate Sub Command1_Click()
Set xlapp = CreateObject("excel.application")
xlapp.Visible = True
Set xlBook = xlapp.Workbooks.Add
Set xlSheet = xlBook.worksheets(1)
xlSheet.Cells(1, 1) = Date$
xlSheet.Cells(1, 2) = Time$
xlSheet.Cells(1, 3) = "123"
xlSheet.Cells(1, 4) = "ABC"
End Sub
Dim xlbook As Excel.Workbook
Dim xlsheet As Excel.Worksheet
Set xlapp = CreateObject("excel.application")
Set xlbook = Workbooks.Open("d:\data\job.xls")
Set xlsheet = xlbook.Worksheets(1)
With DataGrid1
xlsheet.Range("a1") = Adodc1.Recordset.Fields("id")
End With xlbook.Save
xlbook.Close
xlapp.Quit
Set xlapp = Nothing
End Sub就是不知道怎么把第二条记录中字段id的值赋给b1.
Dim xlbook As Excel.Workbook
Dim xlsheet As Excel.Worksheet
Set xlapp = CreateObject("excel.application")
Set xlbook = Workbooks.Open("d:\data\job.xls")
Set xlsheet = xlbook.Worksheets(1)
With DataGrid1
xlsheet.Range("a1") = Adodc1.Recordset.Fields("id")
Adodc1.Recordset.movenext
xlsheet.Range("a2") = Adodc1.Recordset.Fields("id")
End With xlbook.Save
xlbook.Close
xlapp.Quit
Set xlapp = Nothing
End Sub
Dim xlbook As Excel.Workbook
Dim xlsheet As Excel.Worksheet
Set xlapp = CreateObject("excel.application")
Set xlbook = Workbooks.Open("d:\data\job.xls")
Set xlsheet = xlbook.Worksheets(1)
With DataGrid1
xlsheet.Range("a1") = Adodc1.Recordset.Fields("id")
End With '这两条没用上 xlbook.Save
xlbook.Close
xlapp.Quit
Set xlapp = Nothing
End Sub
Dim xlbook As Excel.Workbook
Dim xlsheet As Excel.Worksheet
Set xlapp = CreateObject("excel.application")
Set xlbook = Workbooks.Open("d:\data\job.xls")
Set xlsheet = xlbook.Worksheets(1)
with Adodc1.Recordset
.movefirst
while not .eof
i=i+1
xlsheet.Range("a" & i) = .Fields("id")
.movenext
wend
end with
xlbook.Save
xlbook.Close
xlapp.Quit
Set xlapp = Nothing
End Sub