Printing Reports in Excel

[fastmike]

hi. i am working first time with query and reports. i have created a database. i have reports and query. i have a button in my form by the name of (View reports) if a user clicks on that button it opens another form with 3 options
1) Problems all report
2) problems resolved
3) Problems not resolved
Now what i really want is when a user clicks on Problems all report it should go directly into excel worksheet based on my query which i have assigned and the width, column should be perfect in excel so then a user can print. secondly same thing goes for problems resolved based on my query which wil show all the problems which have been resolved and should open it in excel with everything alligned and ready to print. i know it is possible and i have been able to just print Problems all based on report not with my query and the formatting was really bad. i need to print reports based on my query directly in Excel worksheet with everything perfectly formatted. any help will be really appreciated.
Thanks alot

 

[fastmike]

hi. well this is what i have achieved for the time being. onclick button

Private Sub Problems_resolved_Click()
DoCmd.OutputTo acReport, "Problems resolved", acFormatXLS
End Sub

it works fine. i can save the document in excel worksheet. but here is what my problem is after this i am done . my formatting in excel is totally bad i mean really very bad. it does not show the whole short description field which i have and cells allignment and formatting is totally bad. plz anyone help me out ? i appreciate that.
Thanks