Choosing Excel version

[Floyd Shadwick]

Is there any way to choose the version of excel on a report export?
Currently we are using Office 2007 on a 2003 server in terminal services.
The following code generates an Excel 5.0/95 format.

DoCmd.SendObject ObjectType:=acSendReport, ObjectName:=sReportName,
OutputFormat:=acFormatXLS, TO:=sRecip, cc:=sCC, Subject:=E_SUBJECT,
MessageText:=sMsg, EditMessage:=False

We would prefer Excel 2000.
Does anyone know of any way to do this?

Thanks in advance.

 

[Jeff Boyce]

If I recall, Access HELP includes both correct syntax and examples of
values. I think you can find the alternate OutputFormat value via HELP.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Floyd Shadwick]

There seems to be no other option within Access but acFormatXLS which is
Excel 95. The manual says to change the ODBC to change the version but the
only ODBC driver on the machine is a User DSN that reports the setup routines
cannot be found, please reinstall the driver, when I attempt to configure it.

Are there any functional ODBC drivers for Enterprise Excel 2007 on a 2003 64
bit server?