Runtime 2302 error

[Thompyt]

I tried exporting a query into excel



DoCmd.OutputTo 1, "Final Sponsor", acFormatXLS, "C:\Temp\Sponsor - " & Format(Date, "dd mmm yyyy") & ".xls", , 0

I get "Microsoft Access can't save the output data to the file you've selected."1 should equal a query.

The command works for acReports (3) AcformatXLS works for reports output to xls.

Thanks

[pbaldy]

What is the 0 at the end? It appears to be in the template argument, which would be a path.

[Thompyt]

That worked, Thanks PBaldy

[pbaldy]

No problemo!