question about toolbar corruption

[Brian Murphy]

I have an addin that adds a custom menu every time its opened, and removes
it when its closed. I've been doing this for quite a long time, and I'm
quite sure that under normal circumstances, the adding and removal of the
menu works like it should.

Here's my question.

When excel is closed, if I peek inside the xlb file and see the name of one
of my menu items, does this mean the toolbar has become corrupted to some
extent?

Is there any way to clean it other than reverting to an older or entirely
fresh copy of the xlb file?

Thanks,

Brian

 

[Dave Peterson]

I had never peeked!

But I just did. I didn't see anything that looked vaguely like it was mine
(xl2002).

But in earlier versions of excel (xl2002 seems to behave better based on posts
I've read), that was a way that bloated the .xlb file--just adding items to the
toolbars contributed to the bloat, even if you deleted them later.

I started backing up my .xlb toolbar in xl97 and won't let it xl (any version!)
bloat it. I just copy my backup into the real folder whenever I want (a few
times a week/day, when I'm experimenting in the newsgroups).

I don't think you can do anything to clean it--just wipe it out and revert to a
saved version.

 

[Brian Murphy]

Hello Dave,

I was surprised the other day to see that mine had some bloat in it (xl2002, sp2). About 90k versus a normal 35k.

So I rebuilt it, and I've put a msgbox into my personal.xls that will show me the size of the file every time Excel starts up. It's been about a week now, and the size has not shown any unwarranted increases.

I did do a test where I started my addin that builds my menu, then I killed excel from task manager, and no bloat resulted from that. That's not surprising since the xlb file doesn't seem to get updated until excel closes normally.

Sometimes when testing various odd things, excel crashes while closing. Maybe that's when bloat happens. I haven't had one of these sorts of crashes since I started watching the xlb file size. But I intend to keep watching the xlb size until I eventually catch it.

I use UltraEdit to look at the xlb file. That allows me to see the names of the macros that menus and toolbar buttons are assigned to execute.

Brian

 

[Dave Peterson]

I guess I don't give it too much thought. If I go into see the size, I just
copy|paste a fresh version. (If I made the trip, I might as do something.)

I use UE, too and still don't see anything close to my toolbar captions.

(18k back to 12k today <bg>.)