Calling c# dll from MS Excel vba code - Compile error: Method or data member not found

Question

This is my c# library I from which dll is generated, Also have enabled the COM visiblity in Property -> App,Build

    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using System.Threading.Tasks;
    using System.Runtime.InteropServices;

    namespace howto_dll_for_excel
    {
        [ComVisible(true)]
        [ClassInterface(ClassInterfaceType.None)]
        [ProgId("howto_dll_for_excel.CSharpTools")]
        public class CSharpTools
        {
            [ComVisible(true)]
            public string AddBrackets(string value)
            {
                return "[" + value + "]";
            }
        }
    }

I am trying to access this dll in MS excel using vba as active X

I added the reference of the dll to this vba code,then created a button and this is the macro definition

Sub Button1_Click()
Dim sheet As Worksheet
Dim tools As howto_dll_for_excel.CSharpTools
Dim value As String
Dim result As String
Set sheet = ActiveSheet
value = sheet.Cells(1, 1)
tools = CreateObject("howto_dll_for_excel.CSharpTools")
End Sub

My problem is,

Here the first access of the project howto_dll_for_excel automatically lists the CSharpTools class,

but in the last CreateObject Statement ,it is not listing,even if I type it manually prompts error

"Compile error: Method or data member not found" .

As far as I remember, CreateObject expects a string as input, try CreateObject("howto_dll_for_excel.CSharpTools") — Zohar Peled
– Zohar Peled, Commented Mar 26, 2015 at 6:55
@keerthee do you get the same error or a different error after adding the quotes? — D Stanley
– D Stanley, Commented Mar 26, 2015 at 13:20
Check whether the following registry key exists: HKEY_CLASSES_ROOT\howto_dll_for_excel.CSharpTools . If not then you'll have to register your DLL: regsvr32 c:\path.to\mydll.dll and then try again — Bob Mortimer
– Bob Mortimer, Commented Mar 26, 2015 at 15:26

keerthee · Accepted Answer · 2015-04-15 10:37:51Z

1

The real problem was that, the dll was 32 bit and the excel was 64 bit version

answered Apr 15, 2015 at 10:37

keerthee

8904 gold badges18 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Calling c# dll from MS Excel vba code - Compile error: Method or data member not found

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related