Skip to content

Instantly share code, notes, and snippets.

@xxdoc
xxdoc / mdExcel.bas
Created December 10, 2016 10:21 — forked from wqweto/mdExcel.bas
Write to Excel using ADO
Option Explicit
Public Function WriteToExcel( _
rsSrc As Recordset, _
sFileName As String, _
Optional Workbook As String) As Recordset
Const FUNC_NAME As String = "WriteToExcel"
Dim cn As ADODB.Connection
Dim sSQL As String
Dim oFld As ADODB.Field