VB Error :"Run-time error '53' . File not found: essex

672625
    Hi,
    I have a user with this problem
    Microsoft Visual Basic Error :"Run-time error '53' . File not found: essexcln.xll

    and drop the menu essbase
      • 1. Re: VB Error :"Run-time error '53' . File not found: essex
        timtow
        user6365625 wrote:
        I have a user with this problem
        Microsoft Visual Basic Error :"Run-time error '53' . File not found: essexcln.xll
        I would first try removing the add-in from Tools, Add-ins in Excel, restart Excel, then re-add the add-in in the same dialog.

        BTW, do you have a workbook with some kind of Essbase-related Auto_Open macro or something?

        Tim Tow
        Applied OLAP, Inc
        • 2. Re: VB Error :"Run-time error '53' . File not found: essex
          KRK
          hi frnd,

          This error occurs if user doesnt have essbase installed up on his PC first make sure its installed and then try to connect through add-in.In this way error would be resolved.

          Cheers,
          Ram.
          • 3. Re: VB Error :"Run-time error '53' . File not found: essex
            672625
            Hi, this is a problem with the environment variables, the solution:
            1. PATH variable:

            At a command prompt, enter PATH.

            The PATH statement that is displayed should include the path of the Essbase bin directory.

            For example: C:\>path

            PATH=C:\Hyperion\AnalyticServices\bin

            2. To check the ARBORPATH variable:

            At the command prompt, enter SET.

            The list of variables that is displayed should include the ARBORPATH variable, which specifies the path to the Essbase installation. Also check the drive letter, put the appropriate one.

            For example: C:\>set ARBORPATH= C:\Hyperion\AnalyticServices


            Thanks