471,328 Members | 1,891 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,328 software developers and data experts.

Excel add-in

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

Jul 22 '05 #1
1 2342
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

sc******@yahoo.com 写道:
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

Jul 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Nick Carter | last post: by
5 posts views Thread by touf | last post: by
4 posts views Thread by msnnews.msn.com | last post: by
1 post views Thread by Steven | last post: by
2 posts views Thread by John Walker | last post: by
reply views Thread by strider | last post: by
2 posts views Thread by james | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.