Hello,
I found info to try this
Of course it doesn't work
Is there a better way?Code:Public Sub ExportToExcel() DoCmd.OpenReport acOutputReport, "MembershipStats", acFormatXLS, "\\File02\usfs\Crystal and Excel Reports - Phoenix\CrystalReports\Memberships\MembershipStats" & Format(Date, "yyyymmdd") & ".xls" Exit_ExportToExcel: End Sub
And I would like to use a Macro to run this.