Help exporting a table from access to excel using VBA.

I am looking to be able to export from Access to and Excel template using VBA.  I have read where you can't format an Excel file on export from access, but I thought maybe if I designed a template then I could open it, dump the table data and then save as an excel workbook.

Currently I use the TransferSpreadsheet as listed below...

Is this possible to do?

I thought about something like this:

dim InputRow as integer
InputRow=3

Active_Worksheet.Cells(InputRow, 1) = InputRS.Fields("Field1")
Active_Worksheet.Cells(InputRow, 2) = InputRS.Fields("Field2")
Active_Worksheet.Cells(InputRow, 3) = InputRS.Fields("Field3")
Active_Worksheet.Cells(InputRow, 4) = InputRS.Fields("Field4")
Active_Worksheet.Cells(InputRow, 5) = InputRS.Fields("Field5")
Start Free Trial

1:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, tbl, strXLSName, True