ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Addin File Size (https://www.excelbanter.com/excel-programming/418214-excel-addin-file-size.html)

Rhythm

Excel Addin File Size
 
Any thoughts on control Addin file size? In the past, i could reduce the file
size of an addin, by exporting/removing every module/form, then re-importing
these files, and saving. I think this would also possibly get rid of the
compiled component.
This process does not seem to work with Excel 2007. My particular situation
is I added about 100 lines of code to a program that previously had easily
5-10,000l lines of code that was stored in about 0.5 MB, and now my file has
ballooned up to 4 MB, 8x bigger.
Thanks.

Doug Glancy

Excel Addin File Size
 
Many people use Rob Bovey's Code Cleaner to to what you describe. It looks
like it works in 2007:

http://www.appspro.com/Utilities/CodeCleaner.htm

hth,

Doug

"Rhythm" wrote in message
...
Any thoughts on control Addin file size? In the past, i could reduce the
file
size of an addin, by exporting/removing every module/form, then
re-importing
these files, and saving. I think this would also possibly get rid of the
compiled component.
This process does not seem to work with Excel 2007. My particular
situation
is I added about 100 lines of code to a program that previously had easily
5-10,000l lines of code that was stored in about 0.5 MB, and now my file
has
ballooned up to 4 MB, 8x bigger.
Thanks.





All times are GMT +1. The time now is 03:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com