OutputTo issue

[Cat Chowdy]

I have been using doCmd.OutputTo acReport, stDocName to send a report to
a file. Using Access2003 this command would give me a list of file types to
select from, txt xls, rtf, html, etc. The same mdb, running in Access2007
on a different computer, is missing the xls file type (along with a few
others). Is this an Access2007 issue? What can I do to get the xls type
back?

Thanks,
Cat

 

[Jeanette Cunningham]

Cat,
exporting reports from Access to Excel has been disabled in A2007
(microsoft lost a patent lawsuit).
Here are some alternatives:
Export the query that the report is based on.
Export the report as an htm file which can be opened in excel.
Create a temp table, append the data from the query or queries, format and
massage the data then export a query based on the temp table.

Jeanette Cunningham

 

[Cat Chowdy]

Wow, hard to believe an MS product can't write to an MS product.

Thanks for the suggestions; the query export will work for the excel output.

Cat