How to convert a report to an excel spreadsheet?

V

vanessa

I'm trying to convert an access report to an excel
spreadsheet but is just doesn't work.

I'm using the outputto method:

DoCmd.OutputTo acOutputReport, "myreport",
acFormatXLS, "\\myserver\myreport.xls", False, ""

I'm always getting the following error message:

Microsft can't save the output data to the file you've
selected.
When I'm doing this manually it seems to work fine.
Any help is most appreciated!!
 
Top