access query in excel spreadsheet

hi. i was having reports based on my queries but for some reason when i
tried to use VBA code like
Docmd.output acreports, etc to excel.
the report formatting was totally bad in excel. so by doing some
research i came to know that its better if i try to export my query
rather than query reports. i have a button which will allow the user to
save the report in an excel format(that is what i was doing before). i
was curious if it is possible for me to have some kind of code for my
button or an easy way to output the query in a formatted excel
worksheet?. the docmd.output command works fine for me it will allow
the user to save the file in an excel worksheet but when a user opens
that file the whole excel formatting is bad. any help would be really
appreciated.
Thanks