Passing arrays from Excel (VBA) to C#

J

jlea

Hi - I'm using VS2005/Excel 2007 and can pass scalars from Excel to a C#
class exposed with [ClassInterface(ClassInterfaceType.AutoDual)] and setting
the assembly to Register for COM Interop and all works fine until I try to
pass an integer array from VBA to C#: I initially get "Function or interface
marked as restricted, or the function uses an Automation type not supported
in VB" and when I add "ref" to the C# function I get "Type mismatch: array
or user defined type expected".

Does anyone know what the trick to use to allow passing arrays (and ideally
other data types, objects, and returning various data types to Excel) from
Excel to a C# assembly?

Thanks.

Jon.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing arrays from Excel (VBA) to C# uisng COM interop 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Visual Studio 2010 (Creating Excel DLL) "warning" no build 4
Project 2010 "Project has stopped working" error when attempting to import from Excel 0
Passing an array of strings from VBA to C 1
Passing arrays through procedures 5
Dynamic Creation of Arrays - Sorting into Bins problem 2
Passing Type Arrays 2

Top