Exporting .adp reports to Excel

[AndrewRice]

I am trying to export some reports in my .adp project to Excel. I have discovered the TransferSpreadsheet method, but this does not allow SQL strings. You can only transfer Tables and Queries (which of course don't exist in .adp). I can't use a View because the datasets are user-defined (they have a form to restrict data, when the report opens it builds a SQL string based on that form and I use Me.Recordsource = strSQL) Is there a way to export these reports?
Thanks a lot.

 

[neecie]

Andrew,
You can use the OutputTo method as follows:

DoCmd.OutputTo acOutputReport, "yourReportName",acFormatXLS, "ExcelFilename.xls", [True/False]

If you want to automatically open the excel file set autostart to true (last argument), otherwise set it to false.

You can also specify an excel template to use. I usually leave the default.

Make sure you specify a full path for the excel output file.