3 Replies Latest reply on Jan 6, 2009 3:14 PM by 672625

    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