98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Converting macro based .xls file to 2007 excel .xlsm file - file
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:52Delegate 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:00Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Counting BlanksSome 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. |
