I have an XLA addin created in-house that I am
responsible for updating. I've noticed that the XLA file has grown
much more than the VBA code that I have written, and I don't have a
clue why.
I have been exporting all the code so that I can manage it with
SourceSafe, and noticed that all the raw files, including the BAS,
CLS, FRM and FRX files, all total 263k. The XLA file had grown to
over 800k. I decided to start with a blank XLS file, import all the
code, then save it as an XLA file. The result was a file that was
420k. Everything works as before.
This project uses a third party OCX file, with multiple control
instances on one of the forms, if that makes any difference.
Oh, I did run an antivirus checker. Windows XP Pro, Office 2003 SP1.
Does anyone have an idea what is going on?