| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Inflating in size Q
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File Inflating in size Q
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
| Size Matters - minimizing file size | Excel Programming | |||
| how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
| code to check file size everytime an Excel file is opened | Excel Programming | |||
| How to get the size of the excel file, a sheet size (in bytes)? | Excel Programming | |||
Linear Mode
