Excel 2007 files are always smaller in size because it is really a zip container.
Maybe you can check your usedrange of the sheets in the workbook
See:
http://www.contextures.com/xlfaqApp.html#Unused

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Seanie" wrote in message ...
I am using Ron deBruin's code to e-mail an XLSM file. The code I use
is pretty much as per this link

http://www.rondebruin.nl/mail/folder2/mail3.htm

What I found is that I couldn't open the e-mailed file on a
Blackberry, so I changed the file format to XLS on the file that is
mailed out, and the file size ballooned to 3mb (it was only 295k using
XLSM). Why is that?