Hi. I need to transfer one of reports from my database to Excel file and transfer should be automatically.
I have following code
DoCmd.OpenReport ("xxx"), acViewPreview
---this line allows to print the report
DoCmd.OutputTo acOutputReport, "xxx", acFormatXLS, "issue.xls", True
---second line of code should transfer report xxx to excel file issue. xls or at least any xls file
Code has an error. Please help