Choose Excel Ver with OutpotTo method

[Avi via AccessMonster.com]

Hello,

I'm using OutpotTo method under Access 2007.

When I choose .xls as file format, the Excel file that is being exported is
ver 95.

I want to enforce Access to export Excel ver. 2000-2003 (I can use .xlsx to
craete Ver 2007 file, but I need ver. 2000-2003).

Can it be defined?

 

[Douglas J. Steele]

Use the TransferSpreadsheet method instead.

 

[DrAvi via AccessMonster.com]

Thak you! it is a good alternative.

One more thig - I used another button for "express file send", which send xls
file using docmd. SendObject method.
Is there way to sent xls 2000-2003 file with that or other method?

Avi

Use the TransferSpreadsheet method instead.

Hello,

[quoted text clipped - 9 lines]

Can it be defined?