Choose Excel Ver with OutpotTo method

  • Thread starter Avi via AccessMonster.com
  • Start date
A

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?
 
D

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,
Click to expand...
[quoted text clipped - 9 lines]
Can it be defined?
Click to expand...
Click to expand...
 
Top