G
Guest
I've noticed that the size of my add-in (.xla) has been steadily growing,
although the amount of code and number objects contained within the add-in
has not.
I believe that what is happening is that objects that I create and then
delete are not really getting removed from the file. In particular, I create
a temporary worksheet in the add-to store data which I bind to a ListBox
control. I delete this worksheet after the ListBox control is closed.
This reminds me of something that happens to Outlook Personal Folders files
(.pst). When you delete something from a .pst file, such as old emails, they
don't actually get removed from the .pst file unto you compact it. Compacting
occurs automatically under certain circumstances, but there is a way to do it
manually.
Does anyone happen to know if there is a way to "compact" an add-in file? Or
is there some other explanation?
Thanks for your help.
although the amount of code and number objects contained within the add-in
has not.
I believe that what is happening is that objects that I create and then
delete are not really getting removed from the file. In particular, I create
a temporary worksheet in the add-to store data which I bind to a ListBox
control. I delete this worksheet after the ListBox control is closed.
This reminds me of something that happens to Outlook Personal Folders files
(.pst). When you delete something from a .pst file, such as old emails, they
don't actually get removed from the .pst file unto you compact it. Compacting
occurs automatically under certain circumstances, but there is a way to do it
manually.
Does anyone happen to know if there is a way to "compact" an add-in file? Or
is there some other explanation?
Thanks for your help.