Excel automation using Com

  • Thread starter Thread starter VoTiger
  • Start date Start date
V

VoTiger

Hi,
i want to make my own DLL in DotNet for an Excel use. I have tried COM
but i am facing a little problem... it might be normal but i hope not.
Here is my problem :
I have made a lot of classes that regroup different functions and
properties. My aim is to make a DLL will only properties that refers to
those classes.. so i will be able to have just one DLL that got them
all.
Here is an example of what i expect :
In a first solution :
Public Class MyFunctions1
public function Add1(byVal v1 as double, byval v2 as double) as
double
return v1+v2
end function

public function Divise(byval v1 as integer, byval v2 as integer) as
integer
'....
end function
End Class
And in my DLL solution i have :
Public Class Functions
private l_test as new MyFunctions1

public property test as MyFunctions1
get
return l_test
end get
set(byval value as MyFunctions1)
l_test = Value
end set
end property
end class

I haven't write the Com functions in this mail but they are in my code.
That code works but there is only one problem... In my excel sheet when
i try to see the functions that are in my DLL i only see test... and
not Add1 and Divide... Is there a chance for me to get this ? Or is it
impossible using COM ?

Regards,
C.Marcelino
 
Back
Top