SendObject to specify Excel version

G

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, "[email protected]", _
"[email protected]", , "Daily Numbers", "Auto-Generated", No
 
G

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, "[email protected]", _
"[email protected]", , "Daily Numbers", "Auto-Generated", No
Click to expand...

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