can i run c# code from vba macro?

Question

is it possible to include some kind of libraries inside of VBA that will enable me to use c# functions that i wrote?

please show me some code rather than giving me links – Alex Gordon Jun 06 '10 at 22:55 — Alex Gordon, Jun 06 '10 at 22:55

SLaks · Accepted Answer · 2010-06-06T23:23:02.557

5

You need to expose managed code to COM using the [ComVisible] attribute.

For more information, see here.

EDIT: For example:

[ComVisible(true)]
public class MyClass {
    public int GetNumber(string name) { ... }
}

edited Jun 06 '10 at 23:23

answered Jun 06 '10 at 22:52

SLaks

score 3 · Answer 2 · edited May 23 '17 at 10:33

3

You need to use the ComVisible attribute. Here's a similar question

edited May 23 '17 at 10:33

Community

answered Jun 06 '10 at 22:53

ichiban

2 Answers2