Publish a report to excel?

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

Guest

HI is it possible to publish a report to excel,

without showing the preview window ?


currently i go

DoCmd.OpenReport report, acPreview, ,
 
Try using:

DoCmd.OutputTo acReport, "Acess ReportName", acFormatXLS, "Path/FileName.xls"
This will save it as an excel file with the name you enteted in the path you
specified..

If you want to save it and fire up Excel use:
DoCmd.OutputTo acReport, "Acess ReportName", acFormatXLS,
"Path/FileName.xls",True
 
ur a legend! I couldn't remember the command!

Baffee said:
Try using:

DoCmd.OutputTo acReport, "Acess ReportName", acFormatXLS, "Path/FileName.xls"
This will save it as an excel file with the name you enteted in the path you
specified..

If you want to save it and fire up Excel use:
DoCmd.OutputTo acReport, "Acess ReportName", acFormatXLS,
"Path/FileName.xls",True
Click to expand...
 
This is exactly what I need to do, but I don't understand where to insert
this code.

Please help.

Thank you.
 
Back
Top