How to pass an array from C# function to VBA?

Question

Can it be done?

See codeproject.com/KB/office/arraysvbatocssv1.aspx (and also this comment: codeproject.com/KB/office/… ). It's going the other direction, but it may still help. — Matthew Flaschen
– Matthew Flaschen, Commented Jun 4, 2009 at 5:31
I believe this is answered correctly here: stackoverflow.com/questions/9981404/… — msulis
– msulis, Commented Nov 24, 2012 at 9:40

Robert Harvey · Accepted Answer · 2009-06-04 05:29:07Z

1

You need to create a COM object in C#, and then reference that COM object like you would any other COM object in VB.

Tutorial here: http://www.codeproject.com/KB/COM/com_object_in_c_.aspx

answered Jun 4, 2009 at 5:29

Robert Harvey

182k48 gold badges349 silver badges516 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Yván Ecarri Over a year ago

I think the question is not about creating a COM but about passing an array from c# to VBA once you have a class successfully registered for COM interoperability.

Robert Harvey Over a year ago

This was a long time ago. You're a bit late to the party, aren't you?

Collectives™ on Stack Overflow

How to pass an array from C# function to VBA?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related