I think you'd have to know the inner workings of excel to know why it's
growing. And even if you had that knowledge, I'm not sure if you could stop it
from happening. (But I've never seen the .xlb file grow that big or that fast!)
I'd suggest that you delete the *.xlb file, then recreate it so that you like
it.
Then close excel and back up that new pristine *.xlb file. When you notice that
the file is growing, just copy the backup to the correct location (overwriting
the one that's out of control).
In fact, you may want to set up a small bat file to do this. Then put a
shortcut on the desktop. Click it every so often (with excel closed).
===
Do you add/delete things from your toolbar--either manually or via code? That
could be why it's growing.
> Hi,
>
[quoted text clipped - 9 lines]
>
> Thanks, Rob

Signature
Dave Peterson
Rob - 28 Dec 2005 21:30 GMT
Dave,
Thanks, like the bat file idea. Usually I amend toolbar as and when
required manually but don't do it every time I load Excel. Perhaps a bat
file could overwrite the excel.xla file and start Excel in one go? I'll
look for some code.
Thanks, Rob
>I think you'd have to know the inner workings of excel to know why it's
> growing. And even if you had that knowledge, I'm not sure if you could
[quoted text clipped - 38 lines]
>>
>> Thanks, Rob
Dave Peterson - 28 Dec 2005 22:12 GMT
excel.xla = excel.xlb????
This worked ok for me (saved as a .bat file):
REM ==============
copy "C:\myBackups\excel11.xlb" "C:\Documents and Settings\David
Peterson\Application Data\Microsoft\Excel\XLSTART"
start excel
REM =================
That Copy command was all one line (no line breaks).
> Dave,
>
[quoted text clipped - 51 lines]
> >
> > Dave Peterson

Signature
Dave Peterson
Rob - 29 Dec 2005 16:12 GMT
Thanks Dave, worked a treat. Rob
> excel.xla = excel.xlb????
>
[quoted text clipped - 69 lines]
>> >
>> > Dave Peterson