exporting to excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

,I am trying export a report to excel. This is working however, when I open
the file in excel, the fields are arranged in different orders that they were
in the original report, and I cannot thing of why this is happening. How
frusterating! Any Suggestions?
 
In my experience, reports exported to Excel always look funky. So, I don't
do it. My usual solution is to create a query that presents the day in a
columnular fashion and use TransferSpreadsheet to export to Excel.

My query will usually be very similar to the query I use as the recordsource
for the report. The only differences are that for a report I do all the
summing and totalling at the report level because it is faster than doing it
in the query. For the Excel export, I add the sorting and row oriented
summing. The only thing it is missing is any column totalling or grouping.
I don't see this as a problem, because all that is easy enough to do in Excel.

Where I work now, there is a big demand for Excel verisons of many of our
reports, many of which, require graphs and special formatting. This is
doable, but requires good knowledge of VBA and the Excel object model.
 
Change your tab sequence of your form.

View -> Tab Order

Then click and drag your fields to the appropriate order. Save it, then try
exporting it again...it should appear the way you want it to in excel. It
worked for me
 
Back
Top