Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Excel 2003 launch error with v.1.20.x

Help
Tony
2012-08-24
2013-02-16
  • Tony
    Tony
    2012-08-24

    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?

     
  • SteveT
    SteveT
    2012-08-25

    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

     
  • Tony
    Tony
    2012-08-27

    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

     
  • SteveT
    SteveT
    2012-08-27

    Can you provide a screen shot of the error and the part of the code that is
    highlighted?

    Thanks, Steve

     
  • Tony
    Tony
    2012-08-31

    Sent to you directly.

     
  • SteveT
    SteveT
    2012-09-01

    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.

     
  • Tony
    Tony
    2012-09-04

    Yes, it is listed. Still no solution. Maybe a re-image is in order.

     
  • Tony
    Tony
    2012-09-12

    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.

     
  • SteveT
    SteveT
    2012-09-13

    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

     
  • Tony
    Tony
    2012-09-13

    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.

     
    • Jean D.
      Jean D.
      2013-01-29

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

       
      • SteveT
        SteveT
        2013-02-16

        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