OutputTo Excel defaults to older version

[mbentley]

It looks like some other developers have noticed this, but I've not seen a solution posted.

My code:

DoCmd.OutputTo acOutputQuery, strQuery, acFormatXLS, strFile

Works like it's supposed to, creating a spreadsheet from the SQL statement in strQuery and saving it as the strFile file and path. Problem is that is defaults to Excel 5-7 format when I'm running Access 2000 (XP actually in 2000 mode for compatibility with my users). Does anyone know how to change this?

 

[mbentley]

Thanks Pat. That worked. Funny that they have 2 commands to do the same thing.