Thrown an error on launching Excel 2003 under WIndows XP:
VB Compile Error : Automation Error
Error occured under v.1.20.0, updated to 1.20.2, still get the error.
Debugger highlights Dim cbpMenu As CommandBarPopup
Did a Detect and Repair... on Excel. No joy.
Anyone have any ideas?
Can you check that all the references are enabled. I can't remember how to get
to the VBA IDE in 2003, but if find out, select the Spreadsheet Compare
project (each project uses different references) and click Tools>References.
The following should be checked:
Microsoft Excel 14.0 Object Library
Microsoft Office 14.0 Object Library
Microsoft Forms 2.0 Object Library
Microsoft Windows Common Controls 6.0 (SP6)
Microsoft Visual Basic for Applications Extensibility 5.3
Still no joy.
Visual Basic for Applications - checked
Microsoft Excel 11.0 Object Library - checked
OLE Automation - checked
Microsoft 11.0 Object Library - checked
Microsoft Forms 2.0 Object Library - checked
Microsoft Windows Common Controls 6.0 (SP6) - checked
Microsoft Visual Basic for Applications Extensibility 5.3 - checked
Can you provide a screen shot of the error and the part of the code that is
Sent to you directly.
Thanks, but doesn't really shed anything extra on the problem. I think that is
must be something on your computer. If you click on the word CommandBarPopup
and press F2, the object explorer will appear. In the top dropdown box, select
Office and see if CommandbarPopup is listed in the objects list below.
Yes, it is listed. Still no solution. Maybe a re-image is in order.
Apparently it may be caused by a recent Microsoft security patch. Try the
Will try it.
I completely removed/reinstalled Office 11 and upgraded the Compare add-in. I removed another installation that I had no clue about.
Now the add-in is installed, but I get a warning dialog :
Could not load some objects because they are not available on this machine.
Reinstalled again, to no avail.
All options were installed locally with Office.
See if Microsoft Forms 2.0 Object Library is checked or missing from the VBA references. If it says it is missing, search your PC for the FM20.DLL file and if you find it (you should, it ships with Office), add it as a reference. It is pick it up automatically, but Excel is a funny beast sometimes.
Finally, got it. The reference settings weren't sticking for about 4 of the ones listed above (including Forms 2.0) , so I looked their paths, unregistered and reregistered the lot.
Now I get a launch without issue.
Could you give me a step-by-step procedure to correct the references? I think I got the same problem...
What's the exact problem you have. I am writing some step by step instructions, so it would be useful to see some real world examples.