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:
Private Sub cmdActiveListByEmployeeID_Click()
On Error GoTo Err_cmdActiveListByEmployeeID_Click
DoCmd.OutputTo acOutputReport, "AlphaListing", acFormatXLS, , True
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...