XL5: Run-time Error 1004 or 1006 Using ATP Worksheet Function

• Microsoft Excel for Windows, version 5.0

SYMPTOMS

In Microsoft Excel, when you use one of the Analysis ToolPak worksheet functions, one of the following occurs:

• You receive either of the following error messages:

        Run-time error '1004':
        Run Method of Application class failed
  

        -or-
  

        Run-time error '1006':
        Unable to get the ThisWorkbook property of the Application class
  

  -or-

• The function returns the #VALUE! error value.

CAUSE

These symptoms occur if the workbook that contains the function also contains a module sheet that references the Analysis ToolPak -- Visual Basic for Applications add-in file, ATPVBAEN.XLA.

The error messages occur when you use one of the following worksheet functions:

   EDATE()
   EOMONTH()
   IMSUM()
   NOMINAL()
   TBILLEQ()
   TBILLPRICE()
   TBILLYIELD()

Note that the functions IMSUM() and NOMINAL() return the #VALUE! error value if the Analysis ToolPak--VBA add-in is not loaded.

The following functions return the #VALUE! error value whether the Analysis ToolPak-Visual Basic for Applications add-in is loaded or not:

   GCD()
   LCM()
   MULTINOMIAL()
   IMPRODUCT()
   CUMIPMT()
   CUMPRINC()

WORKAROUND

To avoid receiving these error messages when you use one of the Analysis ToolPak worksheet functions, include the reference to the add-in file with the function name as in the following examples:

   =ANALYSF.XLA!EDATE("1/1/94",5)

   =ANALYSF.XLA!NOMINAL("1/1/94",5)

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel for Windows version 5.0c.

MORE INFORMATION

For additional information, please see the following article(s) in the Microsoft Knowledge Base:

   ARTICLE-ID: Q118797
   TITLE     : "Cannot Find" Using Analysis ToolPak Visual Basic Function

   ARTICLE-ID: Q118799
   TITLE     : XL5: "Argument Not Optional" Using Visual Basic ATP
               Functions