RE:Exportar de SQL a EXCEL (2)
Tambien define estas rutinas en el modulo
Sub Inicia_Excel(ByVal wFileName As String, ByVal wNombreXLS As String)
Dim sXlsTemplate As String
Dim Msg, Estilo, Título
If Right(App.Path, 1) = "\" Then
sXlsTemplate = App.Path & wNombreXLS & ".xls"
sNewXlsFile = App.Path & wFileName & ".xls"
Else
sXlsTemplate = App.Path & "\" & wNombreXLS & ".xls"
sNewXlsFile = App.Path & "\" & wFileName & ".xls"
End If
If Dir(sNewXlsFile) <> "" Then 'Borra archivo Excel anterior
On Error Resume Next
Kill sNewXlsFile
End If
Set objExcel = CreateObject("EXCEL.APPLICATION")
objExcel.Visible = False
objExcel.Workbooks.Open FileName:=sXlsTemplate, ReadOnly:=True, ignoreReadOnlyRecommended:=True
Set oWs = objExcel.ActiveSheet
Set oWb = objExcel.ActiveWorkbook
oWs.SaveAs FileName:=sNewXlsFile, FileFormat:=xlNormal
End Sub
Sub Formatea_ExcelX(ByVal Titulo As String, Cabeceras() As String, Detalle() As String, Filas As Integer, Columnas As Integer)
Dim Msg, Estilo, Título
Dim I As Long, J As Long, K As Long
I = 6 'Empezar en fila 6
' Carga Data al Excel
J=0
While Not rs.EOF
J = J + 1
For K = 1 To Columnas
oWs.Cells(I + J, K + 1) = rs.Fields(K)
Next
rs.MoveNext
Loop
End Sub