C# COM Interop: how to make a method that takes array parameter by value?

Asked Oct 14 '14 at 03:05

Active Oct 14 '14 at 05:30

Viewed 728 times

I'm making a C# interface which my VBA code can call. The method takes an array of string as parameter, and it has to be a ref type, pass by value (without ref in C#) gives me error when calling the function in VBA.

Error when calling the interop method in VBA:

Compile error: Function or interface marked as restricted, or the function uses an Automation type not supported in Visual Basic

edited Oct 14 '14 at 05:30

asked Oct 14 '14 at 03:05

darcyy

5,236
5
28
41

what is the signature of the method? – kennyzx Oct 14 '14 at 03:17
@kennyzx currently it's `object[,] Foo(ref string[] input)`, but I want `object[,] Foo(string[] input)` which give me error when calling in VBA. – darcyy Oct 14 '14 at 04:04
add the information and the error message to the question? – kennyzx Oct 14 '14 at 04:21
Try this [Passing string array from VB6 to C#.net][1] [1]: http://stackoverflow.com/questions/23507416/passing-string-array-from-vb6-to-c-net – Amorphis Oct 14 '14 at 08:29

C# COM Interop: how to make a method that takes array parameter by value?

0 Answers0

Linked