Compiler Issue RRS feed

  • Question

  • Hi,

    I have a tool which was developer in Excel 2007 and MACRO's.

    Few of my user's not able to launch the tool properly.

    Whenever they launch their are getting "Unexpercted Error" In Excel 2010.

    And If they launch in Excel 2007 their getting "Automation Error Catastrophic Failure" Else "Compiler error in hidden module".

    If I make any change in the VB code in the user system and saved the file it's not prompting for any error. The tool is working fine.

    This issue happening for only few user's rest of the user's able to access without any issue.

    Please help me to resolve this issue.


    Karthick M

    Thursday, February 26, 2015 1:50 PM


  • Check the versions of Excel on all users that require this workbook. I have seen this issue before, mine was due to a browsing object I had declared in one of the modules that was not compatible with 32bit Excel. As a result my 64 bit users had no issues while all 32 bit users received the same error.

    You might have to unprotect the code and using a computer that doesn't function debug to determine what line is causing the issue.

    • Proposed as answer by L.HlModerator Monday, March 9, 2015 1:14 AM
    • Marked as answer by L.HlModerator Monday, March 9, 2015 7:57 AM
    Wednesday, March 4, 2015 2:52 PM

All replies