The information in this article applies to:
SYMPTOMSAdding a reference to Microsoft Excel's Type Library from Visual Basic version 4.0 and then early binding an instance of Microsoft Excel's Application Object results in the following error message, when calling a Math function on that object:
CAUSEAll the math functions in the Microsoft Excel Type Library are typed as receiving no arguments, but most of them do have arguments. This is displayed in the help string for the corresponding math function in Visual Basic's Object Browser. RESOLUTIONUse late binding with a generic object. For example, use the following code in the Form_Click event in the "Steps to Reproduce Behavior" section of this article:
STATUSThis behavior is by design. MORE INFORMATIONSteps to Reproduce Behavior
Additional query words:
Keywords : kberrmsg kbprg kbVBp400 IAPVBA VB4WIN vbwin |
Last Reviewed: October 20, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |