Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLA File Size Decrease
All,
I am currently using Excel XP (SP3) and created a complex Add-In, which I passed along to another programmer. The other programmer opened the Add-In and made a very minor VBA code change and then saved the XLA. The file size of the XLA shrunk from 6MB to 4MB. He is also using Excel XP (SP3). I ran a Sourcesafe compare on the code modules and they are all identical (with the exception of the two lines he changed). There are a few hidden worksheets, that are also unchanged. Does anyone have any idea what would cause such a huge change in file size? Thanks, Mark D'Agosta |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLA File Size Decrease
Mark,
probably he did not compile the code. BTW you should be using Rob Bovey's Code Cleaner (if you arent already) http://www.Appspro.com Charles ______________________ Decision Models FastExcel 2.2 Beta now available www.DecisionModels.com "Mark Dev" wrote in message ... All, I am currently using Excel XP (SP3) and created a complex Add-In, which I passed along to another programmer. The other programmer opened the Add-In and made a very minor VBA code change and then saved the XLA. The file size of the XLA shrunk from 6MB to 4MB. He is also using Excel XP (SP3). I ran a Sourcesafe compare on the code modules and they are all identical (with the exception of the two lines he changed). There are a few hidden worksheets, that are also unchanged. Does anyone have any idea what would cause such a huge change in file size? Thanks, Mark D'Agosta |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLA File Size Decrease
Compiled vs not compiled?
-- Thx MSweetG222 "Mark Dev" wrote: All, I am currently using Excel XP (SP3) and created a complex Add-In, which I passed along to another programmer. The other programmer opened the Add-In and made a very minor VBA code change and then saved the XLA. The file size of the XLA shrunk from 6MB to 4MB. He is also using Excel XP (SP3). I ran a Sourcesafe compare on the code modules and they are all identical (with the exception of the two lines he changed). There are a few hidden worksheets, that are also unchanged. Does anyone have any idea what would cause such a huge change in file size? Thanks, Mark D'Agosta |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLA File Size Decrease
Charles,
Thanks for you reply. Yes, that appears to be the case. He did not compile the code, as I always do. I'm unable to locate anything in Microsoft Support that explains exactly what happens during this Compile process that makes the files so much larger (other than a brief explanation of how it does syntax checking, which is the main reason I compile). Do you know where I can get more details on the Compile process? The compiled Add-In does not show any noticeable performance improvement, so I'm wondering what takes place to cause such a huge increase in file size (4MB to 6MB). Thanks again, Mark "Charles Williams" wrote in message ... Mark, probably he did not compile the code. BTW you should be using Rob Bovey's Code Cleaner (if you arent already) http://www.Appspro.com Charles ______________________ Decision Models FastExcel 2.2 Beta now available www.DecisionModels.com "Mark Dev" wrote in message ... All, I am currently using Excel XP (SP3) and created a complex Add-In, which I passed along to another programmer. The other programmer opened the Add-In and made a very minor VBA code change and then saved the XLA. The file size of the XLA shrunk from 6MB to 4MB. He is also using Excel XP (SP3). I ran a Sourcesafe compare on the code modules and they are all identical (with the exception of the two lines he changed). There are a few hidden worksheets, that are also unchanged. Does anyone have any idea what would cause such a huge change in file size? Thanks, Mark D'Agosta |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLA File Size Decrease
Hi Mark,
You can read a detailed discussion of VBA code compilation he http://orlando.mvps.org/VBADecompile...IdC=OrlMoreWin Scroll down below the download link. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm "Mark Dev" wrote in message ... Charles, Thanks for you reply. Yes, that appears to be the case. He did not compile the code, as I always do. I'm unable to locate anything in Microsoft Support that explains exactly what happens during this Compile process that makes the files so much larger (other than a brief explanation of how it does syntax checking, which is the main reason I compile). Do you know where I can get more details on the Compile process? The compiled Add-In does not show any noticeable performance improvement, so I'm wondering what takes place to cause such a huge increase in file size (4MB to 6MB). Thanks again, Mark "Charles Williams" wrote in message ... Mark, probably he did not compile the code. BTW you should be using Rob Bovey's Code Cleaner (if you arent already) http://www.Appspro.com Charles ______________________ Decision Models FastExcel 2.2 Beta now available www.DecisionModels.com "Mark Dev" wrote in message ... All, I am currently using Excel XP (SP3) and created a complex Add-In, which I passed along to another programmer. The other programmer opened the Add-In and made a very minor VBA code change and then saved the XLA. The file size of the XLA shrunk from 6MB to 4MB. He is also using Excel XP (SP3). I ran a Sourcesafe compare on the code modules and they are all identical (with the exception of the two lines he changed). There are a few hidden worksheets, that are also unchanged. Does anyone have any idea what would cause such a huge change in file size? Thanks, Mark D'Agosta |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLA File Size Decrease
Mark,
VBA Code is never stored as the plain text you see in the editor. It is stored as platform/version independent byte-codes, call OpCodes. These codes are converted to text as you edit the module. When you compile VBA code, the OpCodes are translated to platform/version dependent instructions called ExCodes. These ExCodes are read by the VBA runtime library to carry out the actions of the code. The reason that a compiled project is larger is due to the presence of ExCodes. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mark Dev" wrote in message ... Charles, Thanks for you reply. Yes, that appears to be the case. He did not compile the code, as I always do. I'm unable to locate anything in Microsoft Support that explains exactly what happens during this Compile process that makes the files so much larger (other than a brief explanation of how it does syntax checking, which is the main reason I compile). Do you know where I can get more details on the Compile process? The compiled Add-In does not show any noticeable performance improvement, so I'm wondering what takes place to cause such a huge increase in file size (4MB to 6MB). Thanks again, Mark "Charles Williams" wrote in message ... Mark, probably he did not compile the code. BTW you should be using Rob Bovey's Code Cleaner (if you arent already) http://www.Appspro.com Charles ______________________ Decision Models FastExcel 2.2 Beta now available www.DecisionModels.com "Mark Dev" wrote in message ... All, I am currently using Excel XP (SP3) and created a complex Add-In, which I passed along to another programmer. The other programmer opened the Add-In and made a very minor VBA code change and then saved the XLA. The file size of the XLA shrunk from 6MB to 4MB. He is also using Excel XP (SP3). I ran a Sourcesafe compare on the code modules and they are all identical (with the exception of the two lines he changed). There are a few hidden worksheets, that are also unchanged. Does anyone have any idea what would cause such a huge change in file size? Thanks, Mark D'Agosta |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLA File Size Decrease
Rob,
Thanks. This was very informative. Appreciate it. Regards, Mark "Rob Bovey" wrote in message ... Hi Mark, You can read a detailed discussion of VBA code compilation he http://orlando.mvps.org/VBADecompile...IdC=OrlMoreWin Scroll down below the download link. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm "Mark Dev" wrote in message ... Charles, Thanks for you reply. Yes, that appears to be the case. He did not compile the code, as I always do. I'm unable to locate anything in Microsoft Support that explains exactly what happens during this Compile process that makes the files so much larger (other than a brief explanation of how it does syntax checking, which is the main reason I compile). Do you know where I can get more details on the Compile process? The compiled Add-In does not show any noticeable performance improvement, so I'm wondering what takes place to cause such a huge increase in file size (4MB to 6MB). Thanks again, Mark "Charles Williams" wrote in message ... Mark, probably he did not compile the code. BTW you should be using Rob Bovey's Code Cleaner (if you arent already) http://www.Appspro.com Charles ______________________ Decision Models FastExcel 2.2 Beta now available www.DecisionModels.com "Mark Dev" wrote in message ... All, I am currently using Excel XP (SP3) and created a complex Add-In, which I passed along to another programmer. The other programmer opened the Add-In and made a very minor VBA code change and then saved the XLA. The file size of the XLA shrunk from 6MB to 4MB. He is also using Excel XP (SP3). I ran a Sourcesafe compare on the code modules and they are all identical (with the exception of the two lines he changed). There are a few hidden worksheets, that are also unchanged. Does anyone have any idea what would cause such a huge change in file size? Thanks, Mark D'Agosta |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLA File Size Decrease
Chip,
Thanks for the explanation. Just what I was looking for. Regards, Mark "Chip Pearson" wrote in message ... Mark, VBA Code is never stored as the plain text you see in the editor. It is stored as platform/version independent byte-codes, call OpCodes. These codes are converted to text as you edit the module. When you compile VBA code, the OpCodes are translated to platform/version dependent instructions called ExCodes. These ExCodes are read by the VBA runtime library to carry out the actions of the code. The reason that a compiled project is larger is due to the presence of ExCodes. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mark Dev" wrote in message ... Charles, Thanks for you reply. Yes, that appears to be the case. He did not compile the code, as I always do. I'm unable to locate anything in Microsoft Support that explains exactly what happens during this Compile process that makes the files so much larger (other than a brief explanation of how it does syntax checking, which is the main reason I compile). Do you know where I can get more details on the Compile process? The compiled Add-In does not show any noticeable performance improvement, so I'm wondering what takes place to cause such a huge increase in file size (4MB to 6MB). Thanks again, Mark "Charles Williams" wrote in message ... Mark, probably he did not compile the code. BTW you should be using Rob Bovey's Code Cleaner (if you arent already) http://www.Appspro.com Charles ______________________ Decision Models FastExcel 2.2 Beta now available www.DecisionModels.com "Mark Dev" wrote in message ... All, I am currently using Excel XP (SP3) and created a complex Add-In, which I passed along to another programmer. The other programmer opened the Add-In and made a very minor VBA code change and then saved the XLA. The file size of the XLA shrunk from 6MB to 4MB. He is also using Excel XP (SP3). I ran a Sourcesafe compare on the code modules and they are all identical (with the exception of the two lines he changed). There are a few hidden worksheets, that are also unchanged. Does anyone have any idea what would cause such a huge change in file size? Thanks, Mark D'Agosta |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does field size DEcrease when I add a new tab | Excel Discussion (Misc queries) | |||
File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
vba code causes excel charts to decrease in size and become misali | Charts and Charting in Excel | |||
Decrease size of a worksheet so it has fewer than 64,000 rows? | Excel Discussion (Misc queries) | |||
Decrease file size | Excel Programming |