Output TO fails in 2003, works in 2007

[Phil Smith]

I have a database developed in Access 2003. I have upgraded my
development machine to 2007, but much of the rest of the company has yet
to do so.

I have a simple OutputTo command in a Macro.

I am outputting a query to excel 97 - Excel 2003 Workbook, filename is
c:\temp6-9.xls, autostart is yes, output quality is print.

This runs fine when you tun it under 2007. When you run it under 2003,
you get an error:

The format in which you are attempting to output the current object is
not available.

Any Ideas?


Phil

 

[Chutney via AccessMonster.com]

The problem is that OutputTo in 2003 does not support Excel 97-2003. Try
using Excel 5.0/95.