Need to Export Access Report in Excel Format

[bconner]

I have a couple Access Reports that I would like to Export as Excel but I am getting an error saying that Access can't complete the Output Operation.
Below is the code for one of the Reports:

If Option_Ref_Loc_Bad_Debt_By_Paycode = True Then
DoCmd.OutputTo acOutputReport, "Rpt_Ref_Loc_Bad_Debt_By_Paycode", acFormatXLS
End If

Any help is greatly appreciated....

 

[Kafrin]

I had an error using OutputTo with someone else using my database on a different computer. It turned out that they didn't have the latest Access/Office service pack installed, and once they installed it then it worked fine. Might be worth checking whether you have the service packs or not (I think it was SP2 that made the difference, but I'm not totally sure).

A related issue was that their printer and Access didn't like talking to each other and threw up errors whenever you tried to open a report. Try changing the printer for the report and/or the default printer on your computer.

 

[honda882000]

Are you getting a particular error code or just a message?