这是一个例子,可以参考一下原理和楼上的一样 Private Sub Command2_Click() If RecShow.State = 0 Then Exit Sub End If If RecShow.RecordCount = 0 Then Exit Sub Else Dim I As Integer Set excelapp = CreateObject("excel.application") Dim book As New Excel.Workbook Dim sheet As New Worksheet FileCopy SysVal.RptPath & "s_dname.xls", SysVal.SelfPath & TempXls RecShow.MoveFirst excelapp.Workbooks.Add Set book = excelapp.Workbooks.Open(SysVal.SelfPath & TempXls) Set sheet = book.Worksheets(1) excelapp.DisplayExcel4Menus = False excelapp.Range("a1").Value = SysVal.UserName & "药品目录报表" excelapp.Range("b3").Value = Date excelapp.Range("d3").Value = SysVal.PerName I = 5 While Not RecShow.EOF excelapp.Range("a" & I).Value = RecShow("innerid") excelapp.Range("b" & I).Value = RecShow("dname") excelapp.Range("c" & I).Value = RecShow("wbid") excelapp.Range("d" & I).Value = RecShow("pyid") I = I + 1 RecShow.MoveNext Wend excelapp.Visible = True End If End Sub
Private Sub Command2_Click()
If RecShow.State = 0 Then
Exit Sub
End If
If RecShow.RecordCount = 0 Then
Exit Sub
Else
Dim I As Integer
Set excelapp = CreateObject("excel.application")
Dim book As New Excel.Workbook
Dim sheet As New Worksheet
FileCopy SysVal.RptPath & "s_dname.xls", SysVal.SelfPath & TempXls
RecShow.MoveFirst
excelapp.Workbooks.Add
Set book = excelapp.Workbooks.Open(SysVal.SelfPath & TempXls)
Set sheet = book.Worksheets(1)
excelapp.DisplayExcel4Menus = False
excelapp.Range("a1").Value = SysVal.UserName & "药品目录报表"
excelapp.Range("b3").Value = Date
excelapp.Range("d3").Value = SysVal.PerName
I = 5
While Not RecShow.EOF
excelapp.Range("a" & I).Value = RecShow("innerid")
excelapp.Range("b" & I).Value = RecShow("dname")
excelapp.Range("c" & I).Value = RecShow("wbid")
excelapp.Range("d" & I).Value = RecShow("pyid")
I = I + 1
RecShow.MoveNext
Wend
excelapp.Visible = True
End If
End Sub