Help with formatting an excel spreadsheet

lushh · October 1st, 2006, 10:48 PM

hi guys. i am currently using ms access 2003. i want to export my reports to an excel file so i did a code like this:

Code:

Private Sub cmdActiveListByEmployeeID_Click()

On Error GoTo Err_cmdActiveListByEmployeeID_Click

DoCmd.OutputTo acOutputReport, "AlphaListing", acFormatXLS, , True

Exit_cmdActiveListByEmployeeID_Click:
    Exit Sub

Err_cmdActiveListByEmployeeID_Click:
    MsgBox Err.Description
    Resume Exit_cmdActiveListByEmployeeID_Click
End Sub

the problem is that when the reports are being exported, data such as dates are not displayed properly on excel. the dates are converted into texts. fonts do also vary. how can i be able to format the excel spreadsheet so that the reports will be shown properly?

thanks in advance...