Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing arrays from Excel (VBA) to C# uisng COM interop
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing Arrays to SUBs | Excel Programming | |||
Passing Arrays from Excel to Word | Excel Programming | |||
Passing arrays to VBA module | Excel Programming | |||
passing arrays between functions in VBA | Excel Programming | |||
Passing arrays to a subroutine | Excel Programming |