SendObject to specify Excel version

[GVR_Mike]

It appears that there is only one OutputFormat to choose to send
export a table to Excel and send it via e-mail, acFormatXLS. This
seems to be sending the file as Excel 95 and is giving some of the
recipients problems. Is there a way to specify to send the file as
Excel 97 or 2003? Here is my code ("Daily Performance Statistics" is
the name of the table):

DoCmd.SendObject acSendTable, "Daily Performance Statistics",
acFormatXLS, "(e-mail address removed)", _
"(e-mail address removed)", , "Daily Numbers", "Auto-Generated", No

 

[GVR_Mike]

It appears that there is only one OutputFormat to choose to send
export a table to Excel and send it via e-mail, acFormatXLS. This
seems to be sending the file as Excel 95 and is giving some of the
recipients problems. Is there a way to specify to send the file as
Excel 97 or 2003? Here is my code ("Daily Performance Statistics" is
the name of the table):

DoCmd.SendObject acSendTable, "Daily Performance Statistics",
acFormatXLS, "(e-mail address removed)", _
"(e-mail address removed)", , "Daily Numbers", "Auto-Generated", No

By the way, I'm using Access 2000. Not sure if a newer version will
have more options or not.