File Inflating in size Q

[Seanie]

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?

 

[Ron de Bruin]

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