'Haber amigo prueba esto, con esta pista me imagino que te las ingeniaras para completar los demas. no esta muy dificil.
Private Sub ExcelEsport(rs As ADODB.Recordset)
Dim D As String
rs.MoveFirst
'On Error GoTo Etiqueta
Dim ApExcel As Variant
Set ApExcel = CreateObject("Excel.application")
With ApExcel
.Visible = True
.Workbooks.Add
.Cells(1, 1).Formula = UCase$("Cia. Industrial Continental S.R.L")
.Range("A1:D1").Font.Bold = True
.Cells(2, 1).Formula = UCase$("Inventario de Cajamarquilla al 29/06/2004")
.Cells(3, 1).Formula = UCase$(Titulo)
.Cells(4, 1).Formula = "AREA: " & DtAlmacen.Text
.Range("A2:D4").Font.Italic = True
Dim X As Integer
Dim Y As Integer
Y = 6
For X = 1 To rs.Fields.Count
.Cells(Y, X).Formula = rs.Fields(X - 1).Name
DoEvents
Next
Do Until rs.EOF
Y = Y + 1
For X = 1 To rs.Fields.Count
D = Chr(X + 64) & Y
.Range(D).Formula = CStr(rs.Fields(X - 1))
DoEvents
Next
rs.MoveNext
DoEvents
Loop
.Range("A6:" & D).Borders.Color = RGB(0, 0, 0)
End With
Set ApExcel = Nothing
' Exit Sub
'Etiqueta:
'
' MsgBox Err.Description, vbInformation, App.Title
End Sub