Publish a report to excel?

[mike_mike]

HI is it possible to publish a report to excel,

without showing the preview window ?


currently i go

DoCmd.OpenReport report, acPreview, ,

 

[Baffee]

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

 

[mike_mike]

ur a legend! I couldn't remember the command!

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

 

[a_ryan1972]

This is exactly what I need to do, but I don't understand where to insert
this code.

Please help.

Thank you.

 

[PieterLinden via AccessMonster.com]

This is exactly what I need to do, but I don't understand where to insert
this code.

Please help.

The click event of a button...