Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hy,
Let's say I have a dll made in VB6. This dll contains 3 class modules(ClassA, ClassB, ClassOper) and one module(MyFunctions). In MyFunctions I have a function like this: Public Function DoSome(collecFirst as Collection, collecSecond as Collection, objA as ClassA, objB as ClassB) as Double. In ClassOper I have the function: Public Function DoSomething(collecFirst as Collection, collecSecond as Collection, objA as ClassA, objB as ClassB) as Double If (IsValid) Then DoSomething = DoSome(collecFirst, collecSecond, objA, objB) Else DoSomething = -10000 End Function I have an Excel woorkbook that use this dll. Let's say I have a macro in Excel called TestDll Public Sub TestDll() Dim myOper as ClassOper Set myOper = New ClassOper MsgBox myOper.DoSomething(myCollecFirst, myCollecSecond, myObjA, myObjB) End Sub When trying to run TestDll I get the following error: "argument not optional Error 449" Can somebody help me with this? (I hope that my example I good..) Thanks and best regards, O |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compile Error Argument Not optional | Excel Discussion (Misc queries) | |||
Compile Error: Argument not optional | Excel Programming | |||
error message: compile error, argument not optional | Excel Programming | |||
optional argument in a function | Excel Programming | |||
Complie Error- Argument not optional | Excel Programming |