A Simple C# DLL – how do I call it from Excel, Access, VBA, VB6?

by

You can’t access a static member via COM interop. In fact your code doesn’t even compile, the method should be in a class. Here is how you can do it:

[InterfaceType(ComInterfaceType.InterfaceIsDual)]
[Guid("01A31113-9353-44cc-A1F4-C6F1210E4B30")]  //Allocate your own GUID
public interface _Test
{
    string HelloWorld { get; }
}

[ClassInterface(ClassInterfaceType.None)]
[Guid("E2F07CD4-CE73-4102-B35D-119362624C47")]  //Allocate your own GUID
[ProgId("TestDll.Test")]
public class Test : _Test
{
    public string HelloWorld { get { return "Hello, World! "; } }
}

The project properties Build tab, select Register for COM interop. So you can see the results quickly. To install the dll on another machine you need to use regasm.

To then consume this:

Dim o : Set o = CreateObject("TestDll.Test")
MsgBox o.HelloWorld

You can also reference the dll and use early binding:

Dim o As TestDll.Test
Set o = New TestDll.Text
MsgBox o.HelloWorld

More Related Contents:

  1. How to use Microsoft.Office.Interop.Excel on a machine without installed MS Office?
  2. How do I properly clean up Excel interop objects?
  3. Write Array to Excel Range
  4. Excel Interop – Efficiency and performance
  5. Exception from HRESULT: 0x800A03EC Error
  6. Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))
  7. Microsoft.Office.Interop.Excel really slow
  8. Excel interop: _Worksheet or Worksheet?
  9. 64 bit C# with a 32 bit VB6 COM object
  10. How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?
  11. C# – How to copy a single Excel worksheet from one workbook to another?
  12. Resources for learning c# Excel interop [closed]
  13. No definition found for GetActiveObject from System.Runtime.InteropServices.Marshal C#
  14. Compile C#.net dll for VB6
  15. how to solve Exception:Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED)) in C#?
  16. Making a C# kill event for a vb6 app?
  17. Printing Excel using Interop
  18. .Net Excel Interop Deleting a worksheet
  19. How to deal with files with a name longer than 259 characters?
  20. Export DataTable to Excel with EPPlus
  21. Fastest way to interface between live (unsaved) Excel data and C# objects
  22. How do I handle null or optional DLL struct parameters
  23. C# create/modify/read .xlsx files
  24. How to read single Excel cell value
  25. How to get the location of the DLL currently executing?
  26. Where to find “Microsoft.VisualStudio.TestTools.UnitTesting” missing dll?
  27. C# call C++ DLL passing pointer-to-pointer argument
  28. Reading from Excel (Range into multidimensional Array) C#
  29. Scientific notation when importing from Excel in .Net
  30. Accessing an open Excel Workbook in C#

Leave a Comment