- + P A

- 2例导出EXCEL的方法(ado recordset 与 MSHFlexGrid 导出EXCEL )

      ADO_EXCEL 2008-6-28 18:25

Public Function Rs_To_Excel(Rs_data As ADODB.Recordset)
On Error Resume Next

'*********************************************************
'* 名称:ExporToExcel
'* 功能:导出数据到EXCEL
'* 用法:ExporToExcel(sql查询字符串)
'*********************************************************
Dim Irowcount As Long
Dim Icolcount As Long
   
    Dim xlApp As New excel.Application
    Dim xlBook As excel.Workbook
    Dim xlSheet As excel.Worksheet
    Dim xlQuery As excel.QueryTable
   
  
   
    If Rs_data.RecordCount < 1 Then
    

标签集:TAGS:
我要留言To Comment 阅读全文Read All | 回复Comments() 点击Count()