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

OLE Automation

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
highlighted?

Thanks, Steve

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
steps here:

http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012
/08/15/quot-unspecified-automation-error-quot-after-applying-ms12-060.aspx

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 :
Microsoft Forms
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.

Steve

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.
Thanks.

Tony,
Could you give me a step-by-step procedure to correct the references? I think I got the same problem...
Regards

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.

Thanks, Steve