Excel add-in

[schouwla]

I am a dotnet newbie..

Does anyone have experience with building an Excel add-in using dotnet?

NOW:
Currently I have programmed a VBA add-in that calls some C++ functions
in a dll.
The VBA code calls another VBA add-in for getting out market data (not
programmed by me).

POSSIBLE FUTURE ARCITECTURE:
I need to manipulate an Excel sheet so I guess I need vb.net for that?

If I want to create an Excel add-in then I only do that using C#?

How can vb.net and C# interact?

I still want to maintain my unmanaged C++ dll because I am doing
montecarlo simulations so need the performance of C++. Can vba.net call
an unmanaged C++ dll?

Any links to articles or code samles would be apreciated.

Regards
Lars Schouw

 

[Wayne Wood]

no problem i think

there're good supports for VB.NET or C# addin development for Excel
(actually every Office application)

there's no problem in interaction between vb.net and C#, you can
encapsulate the separate language code into separate assemblies, and
then do any references. or you can use basic tools provided by vs.net
to do it more freely.

calling typical C++ dll in VB.NET, according to my experience, will not
be difficult at all, but you have to pay enough attention on data type
conversion and so on, there'll be more details when you are on your real
way.

good luck

(e-mail address removed) 写é“: