如何利用自動化將 ADO 資料錄集中的資料傳送至 Excel

如何利用自動化將 ADO 資料錄集中的資料傳送至 Excel

瀏覽:322
日期:2024-07-14
Private Sub Command1_Click() Dim cnt As New ADODB.Connection Dim rst As New ADODB.Recordset Dim xlApp As Object Dim xlWb As Object Dim xlWs As Object Dim recArray As Variant Dim strDB As String Dim fldCount As ......看更多