Access 2007 DoCmd.OutputTo acOutputReport ... acFormatXLS

[niki09]

I found a post in this forum on out outputting a report to Excel using access 2007, saying that it does not work.

This is what I am trying to do with access 2007 (hoping that the problem has now been fixed):
DoCmd.OutputTo acOutputReport, "total", acFormatXLS, "c:\personal\pdf_files\report.xls", True
The error says access cannot save the data to the output file.

If I go to the Report itself, and right click, I can save it as excel.
So perhaps it now does work in vb but I have got something wrong.




Thanks

[June7]

Is the computer on a network? Is the db on the network server? Sometimes things that can be done manually are not allowed by the network when done programmatically as with VBA.

Try saving to the C:\ root level and see if the command works.

[alansidman]

Alternatively, I would attempt to use Docmd.TransferSpreadsheet.

Look here for a syntax tutorial. https://msdn.microsoft.com/en-us/lib.../ff844793.aspx

[niki09]

thank you for the suggestions.
no joy with trying to save to the root directory.
my computer is a stand alone machine.
Transfer spreadsheet could not work (as I am trying to save a report as an excel, rather than table?)

[June7]

Don't know what to tell you. I am sure the method worked for me when I had 2007.

Is the report open in PrintPreview?

[niki09]

Dear group, I get emails from your system on this topic. The last reply was essentially we do not know, which is fine. Can someone close this please.

[June7]

Closing locks a thread and prevents new posts. Seldom do this.