+ Reply to Thread
Results 1 to 3 of 3

Utilizing a dll in Excel VBA

  1. #1
    Registered User
    Join Date
    01-14-2008
    Posts
    21

    Utilizing a dll in Excel VBA

    Hi there.
    Complex issue for real experts
    Following is the topic.
    I have realized a class in VB6. This class realizes a calculation.

    The final aim is to compile it in a dll and utilize it by VB module of excel.
    Now:
    I have realized a form in VB studio, and by the form I have passed the input parameters to the class. All is working fine.
    By the way, Class and form belong to the same project.

    After that, with the sole class, I have realized a new project and I have compiled it in a dll.

    I have then
    - utilized the same code of the form in excel VB module to call the class.
    - put the compiled dll into references

    Unfortunately I don’t get any result.

    Please, may I ask you if it is an error in the dll calling in excel, or if you think there may be some other mistakes ?
    Thanks

  2. #2
    Forum Contributor
    Join Date
    06-09-2011
    Location
    Germany
    MS-Off Ver
    Excel 2016
    Posts
    194

    Re: Utilizing a dll in Excel VBA

    maybe a stupid question - did you register the dll usin rgsv32?

    Regard

    Theo
    Remember To Do the Following....
    1. Upload sample files
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

  3. #3
    Forum Contributor
    Join Date
    06-09-2011
    Location
    Germany
    MS-Off Ver
    Excel 2016
    Posts
    194

    Re: Utilizing a dll in Excel VBA

    maybe a stupid question - did you register the dll usin rgsv32?

    Regard

    Theo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1