Converting macro based .xls file to 2007 excel .xlsm file - file

Resolved · Medium Priority · Version 2007

Wed 23 May 2012, 15:47 Edited on Wed 23 May 2012, 15:52 Delegate Maria said...

Maria has attended:
Excel Intermediate course
Excel Advanced course

Converting macro based .xls file to 2007 excel .xlsm file - file

When I convert a macro based Excel 2003 file .xls (size 13meg) to Excel 2007 file .xlsm (size initially reduces). When I run the macros in the .xlsm file the size increases to 37meg.

The macros work but why does the file size double or in some cases treble?

Wed 30 May 2012, 08:00 Trainer Mark said...

RE: converting macro based .xls file to 2007 excel .xlsm file -

Hello Maria,

Re your question, unfortunately that is how VBA is compiled and despite many developers trying to avoid large user ranges or public variables or clearing variables the size still remains. Microsoft are not very forthcoming regarding how the low level coding works.
Sorry for not providing any suggestions but unfortunately it's something that cannot be changed.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Wed 6 Jun 2012: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

View all Excel hints and tips