Export report as excel file

  • Thread starter Thread starter Leslie Isaacs
  • Start date Start date
L

Leslie Isaacs

Hello All

I am using Access97, and I want the ability to export various reports to
excel, via a macro. When I do this the formatting of the report is often
messed up - especially the column headers: extra column headers are
frequently added to the left of what should be the first column - with no
data in these extra columns. Why is this hapenning - and more to the point
how can I stop it?

Many thanks

Leslie Isaacs
 
Leslie, export to excel is tricky to say the least, if labels and/ot text
boxes are not exactly alligned on the left, they often end up in different
columns in excel. The box width also can cause the data to end up in
separate columns. When I need to export to Excel I usually export directly
from a table or query, this way all data will end up in the specific columns
without fail.
Hope this helps.
Fons
 
Back
Top