e-mail a excel file

[john]

Which format should be used in saving a Excel file, if
the file is e-mailed to a recipient, and the file is to
be opened also in the same excel format.

 

[Ken Wright]

Would honestly recommend you save yourself all the grief of worrying about it,
and take advantage of Ron De Bruins free SendMail addin, which will give you
choices galore and actually make you aware of options you didn't even know you
had when sending data:-

http://www.rondebruin.nl/sendmail.htm#Add-in