Menu ▾ ▴

#36 Compile Error Can't find project or library - $chr$(0)

Current_Version
pending
nobody
None
1
2014-10-10
2013-03-22
Anonymous
No

Here is a screen shot of what happens when I start the MS Excel

1 Attachments
CompareBug.pdf

Discussion

  • SteveT

    SteveT - 2013-03-24

    There are some instructions in the help file that you should review. You can also follow the instructions below. Let me know which fixes the issue.

    If this appears when starting Excel, perform the following:
    1. Click the square stop button to stop the code.
    2. Determine if there are any MISSING references ('Tools>References') and fix them.
    3. If listed, uncheck the 'Microsoft Office Object Library' and see if this fixes the issue.

    Thanks, Steve

     

    • Anonymous

      Anonymous - 2013-03-28

      Hi Steve - by doing steps 1 and 2 I found out that I am missing MSCOMCTL.OCX. I have tried to carry out step 3, but it did not help. So I have downloaded the MSCOMCTL.OCX from Microsoft. When I try to register it by running "C:\Windows\SysWOW64\regsvr32.exe MSCOMCTL.OCX" I get mysterious error "...The module MSCOMCTL.OCX was loaded but the call to DLLRegisterServer failed with error code 0x80004005..." so the plot thickens. Currently trying to figure out what this message means. Would welcome any comment you may have.

       

    • Anonymous

      Anonymous - 2013-03-28

      Hello SteveT it appears I am missing MSCOMCTL.OCX. I have now downloaded it but get "...The module MSCOMCTL.OCX was loaded but the call to DLLRegisterServer failed with error code 0x80004005..." when trying to register it with a command "c:\windows\syswow64\REGSVR32 MSCOMCTL.OCX". So any suggestion would be welcome

       

  • SteveT

    SteveT - 2013-03-24
    • status: open --> pending
     

  • SteveT

    SteveT - 2013-03-28

    Try this (but use MSCOMCTL.OCX instead of mscomct2.ocx):

    You need to copy the MSCOMCT2.OCX file to c:\windows\sysWOW64 not c:\windows\system32. You then can register it by running from the command prompt or run in the start menu regsvr32 c:\windows\sysWOW64\mscomct2.ocx and it should register although make sure that you run regsvr32 with administrator privileges.

    How to run that command in Administrative Mode

    1. Click the Start button, then in the "Start Search" box, type CMD but DO NOT press Enter yet.
    2. In the list above, under "Programs" right-click on CMD that appears above and choose "Run as Administrator" and click "Continue".
    3. In the open window, type the following command and press Enter:

    regsvr32 c:\windows\sysWOW64\mscomct2.ocx

    from here: http://social.technet.microsoft.com/Forums/en-US/w7itprogeneral/thread/1fd6b78a-b1b3-4190-aceb-91575cd7092a/

    Steve

     

  • Anonymous

    Anonymous - 2013-11-25

    I have experienced this error message as the macro doesn't run in Office 2003 - to resolve the issue you need to qualify the module names like Strings.Chr$() and Interaction.Environ() etc. If I go through the code doing this it works without prompting the message. I tried to download the source via CVS to make these changes but failed.

     

  • Anonymous

    Anonymous - 2013-11-26

    Thank you for your reply however I'm finding that when I start Spreadsheet Compare in Excel 2003 I get the message "can't find project or library" the function Format() is highlighted in the mdlClipboardFunctions.PutOnClipboard() method. I find that if I qualify the function with Strings.Format() resolves the issue. My main problem after this is that I can't save the xla because its read only any ideas on how I can save my code changes?

     

    • SteveT

      SteveT - 2013-11-27

      Probably the Add-In is installed in a location that cannot be saved (because of UAC, etc.). You can 1) try moving the Add-In, opening, making the changes and saving it back there (details in the help file), or you can 2) stop the project at the error and fix the reference (I am almost certain this is the issue) using the help provided above. One checkbox check will save you a lot of time. I would go for option #2. If you do option #1, you will have the same issue after the next release.

      Also, please create a new thread for any new issues.

      Thanks, Steve

       

      Last edit: SteveT 2013-11-27

  • Anonymous

    Anonymous - 2013-11-29

    Okay thanks for your help I tried option #2 with the references but I still need to save the xla file otherwise I am prompted with problem every time I open Excel.

    I'll try option #1 to re-install to a different folder.

     

  • Anonymous

    Anonymous - 2013-11-29

    Sorry Steve as you pointed out UAC I just realised I needed to have the RunAs Administrator option ticked when opening Excel then I am allowed to save xla file.

    I corrected the missing library file clicked save and now Excel 2003 opens with no problems when run as Admin.

    Thanks for you advice.
    :)

     

    • SteveT

      SteveT - 2013-11-30

      Great. Glad it worked out.

      Steve

      Sent from Yahoo Mail on Android

       

  • niknah

    niknah - 2014-10-10

    Does this software work on 32 bit computers? I don't have c:\windows\syswow64
    And the common controls are always MISSING, even after doing the things mentioned here.

     

    • SteveT

      SteveT - 2014-10-12

      Yes, it will work. Have you tried the Install and Troubleshooting here:

      http://www.thefoolonthehill.net/drupal/sites/default/files/WebFM/admin/help/Spreadsheet_Compare/Spreadsheet%20Compare%20Help.html?Introduction.html

      If you still have an issue, raise a new support request and post some screenshots.

       

      • niknah

        niknah - 2014-10-13

        I got it to work thanks.

        Tried it on 3 different computers. First one wouldn't add the ocx. 2nd one had some other interior.colorIndex error. Then the 3rd was good.

         

Log in to post a comment.