Export to excel

[krc547]

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.

 

[CJ_London]

Check the parameters- looks like you need to include a file name

 

[krc547]

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.

 

[Gasman]

Try using the Intellisense ?