Choosing Excel version

  • Thread starter Thread starter Floyd Shadwick
  • Start date Start date
F

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.
 
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
 
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?
 
Back
Top