How to format excel

[lushh via AccessMonster.com]

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

 

[Douglas J. Steele]

See whether my July, 2005 "Access Answers" column in Pinnacle Publication's
"Smart Access" helps.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[lushh via AccessMonster.com]

hi. thanks for the reply... but i think it's quite complex.. are there any
simpler ways to do that? sorry, i've been only using access and vb for 2
months now.. and i am not really that familiar with the program.. sorry for
the inconvenience..

See whether my July, 2005 "Access Answers" column in Pinnacle Publication's
"Smart Access" helps.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

hi guys. i am currently using ms access 2003. i want to export my reports
to

[quoted text clipped - 22 lines]

thanks in advance...

 

[Douglas J. Steele]

Nothing simpler that I'm aware of.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

hi. thanks for the reply... but i think it's quite complex.. are there any
simpler ways to do that? sorry, i've been only using access and vb for 2
months now.. and i am not really that familiar with the program.. sorry
for
the inconvenience..

See whether my July, 2005 "Access Answers" column in Pinnacle
Publication's
"Smart Access" helps.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

hi guys. i am currently using ms access 2003. i want to export my
reports
to

[quoted text clipped - 22 lines]

thanks in advance...

 

[lushh via AccessMonster.com]

OK. Thank you for your time. I'll just take time to study your module.. God
bless... =)

Nothing simpler that I'm aware of.

hi. thanks for the reply... but i think it's quite complex.. are there any
simpler ways to do that? sorry, i've been only using access and vb for 2

[quoted text clipped - 15 lines]