Excel automation using Com

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • VoTiger

    #1

    Excel automation using Com

    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

  • VoTiger

    #2
    Re: Excel automation using Com

    Up

    Comment

    Working...