Method 'Add' of object 'CommandBarControls' failed

[Casey]

I have encountered a problem with an Commercial Addin program by J-Wal
and Associates "PUP2000". I have used this Addin for years and hav
never had a problem with it, ever. I also have a fine addin by Ron d
Bruin "Google 6.0" which is great. The reason I mention both of thes
addins is because Ron's Google 6.0 is working fine, but John's (Joh
Walkenbach) PUP2000 menu does not load at all when I start Excel. Ron'
Google 6.0 does get added but perhaps it's because Ron's product onl
adds an item to the existing Help menu. The actual error message tha
shows when I start Excel is:

Microsoft Visual Basic
Run-time error '-2147467259 (800O4005)':
Method 'Add' of object 'CommandBarControls' failed

Stats
Running Window XP Pro Service Pack 1
MS Office 2002 Excel version (10.6501.6625) SP3

What I have tried
I have unistalled and reinstall Pup 2000 from the CD
I have ran Regedit and deleted the the following:
"HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Common\Toolbars\Settings\Microsof
Excel",
I have ran Excel's "Detect and Repair"
None of these have worked.

I do light programming with VBA, but none of my programming deals wit
making new menus or menu items. So I don't think I inadvertantly wrot
some kind of malicious code.

Any help or suggestions would be greatly appreciated
I love PUP 2000 and I would really like it to work again.

TIA
Case

 

[Ron de Bruin]

Hi Casey

Try this

This can be a corrupt or bloated toolbar file
The .xlb file has all Toolbar customization in it.

Close Excel
Do a search for .xlb in windows
Rename the file you find (my file is named Excel10.xlb in 2002)
Start Excel

Deleting the file or renaming will do no harm on your system
Excel will create a new one for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
This file is important (backup it so you can restore it)

 

[Casey]

Ron,
Worked like a magic wand. Thank you. And thank you for your fine searc
tool Google Search 6.0, it has opened a treasure chest of resources fo
me, that has added to my VBA education

 

[Ron de Bruin]

Hi Casey

You are welcome

Thanks for the feedback