Export to excel (1 Viewer)

krc547

Member
Joined
Sep 1, 2023
Messages
38
I have a button on my report and have this as the code:

DoCmd.OutputTo acOutputReport, "rFiscal-Month Comparison", acFormatXLSX, "C:\Users\kcummings\Desktop", True

But it just errors out and says it can not export the report.
 
Check the parameters- looks like you need to include a file name
 
That was it, I forgot to give it a name. I have a parameter in the report that asks for the fiscal year. But then when I click the button to export the report it asks me the same questions like 5 times before it actually exports the file.
 

Users who are viewing this thread

Top Bottom