Help with formatting an excel spreadsheet

[lushh]

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

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...

[JohnFitz]

Did you try to run the report from a query and then in datasheet view and then "Tools/Analyze in Excel?

[lushh]

hi, thanks for the reply. yup, but will that option be available when i make an MDE file of that database? and as much as possible, i want to make the database formal and user-friendly since i won't be the end-user of this database.and i think it would be better to create buttons for report generations... =)

[PEB]

Hi,

Have you tried to format your date in your query?

Maybe it's better to use Cvdate([Your Date]) in your query!

And I suppose that your date will appear as date in Excel conforming your Regionnal Settings...

If this don't work there is others ways to resolve the problem...


Best regards..