C
chris1980
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
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