Export Report to Excel

  • Thread starter Thread starter dbl
  • Start date Start date
D

dbl

Hi how do you export a Access 2003 report to Excel 2003 using code?

I want to export the report after it has been previewed because date is
updated as and when it opens.

So I want to open the report then send it straight to Excel using code.

Thanks Bob
 
Hi how do you export a Access 2003 report to Excel 2003 using code?

I want to export the report after it has been previewed because date is
updated as and when it opens.

So I want to open the report then send it straight to Excel using code.

Thanks Bob
Click to expand...

DoCmd.OutputTo

either that or use one of Stephen Lebans' routines. www.lebans.com
 
I have used the OutputTo feature in my coding. My report exports into Excel
just fine for the most part. There is some grand totals in the report
footer. Those totals export fine but there are 3 fields that are identifiers
in the footer that do not export into Excel. One is the date and another is
the headquarters number and name. I guess I am at a loss as to why the grand
totals of columns export but the others do not
 
Back
Top