VBA calling C#

[david_fryda2]

Hi everyone,

Is there a way to call functions that I created in C# from a VBA program ?

Thnaks a lot.

Regards.

[reiner_hille-doering · Accepted solution]

Yes, with COM interop: expose your C# class with a COM interface of type Dual or dispatch and register the assembly with regasm.

[david_fryda2 · Accepted solution]

Hi Reiner,

Thanks for the quick answer.

Nice day.

PS :

a) By the way, do you have a tutorial about how creating COM interop ?

b) Should I use DCOM ?

Thanks!

Message was edited by: David Fryda

[reiner_hille-doering · Accepted solution]

a) Here are some links (or google for regasm vb tutorial)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/csref/html/vcwlkcominteroppart2cser...

http://www.vbrad.com/pf.asp?p=source/src_real_interop.htm

http://www.vbdotnetheaven.com/Code/May2004/AccessNetCompsFromVBIA.asp

http://www.programmersheaven.com/2/vbrad-Interop

b) No, you use local COM.

[david_fryda2 · Accepted solution]

Thanks again Reiner.