Should we use VB.net or VB6 to create an add-in?

[Tee]

I am starting to learn how to build a Com add-in for Excel. Most reference
that I could find use VB6 to create add-in. While I understand that VB.net
is an entirely different programming language, is there any obvious
disadvantages/advantages of using VB.net for add-ins? Is there any known
difficulties for the programming or distributing VB.net add-in, compare to
using VB6?

Please recommend if you know of any book that covers VB.net add-in for
Excel. Thanks!

Tee Theng

 

[Guest]

Tee
..net development for Office by Andrew Whitechapel is probably what you want
(although thats C# its near enough to vb.net) also
professional Excel Developement by Bullen Bovey and Green has a decent
discussion of vb6 v .net.

Which is best will depend on what you are planning to do. VB6 is still a
viable development tool, but future wise .net is likely to be where its at.

The main advantage of .net is probably security, distribution depends on the
client machine config, if they have the .net runtime then great, if not vb6
may be easier.

cheers
Simon

 

[Tee]

Thanks Simon

I have a few frequently used formulas that I wish to move out of VBA into
VB/VB.net Add-In. My main purpose is so that I could
1. Protect the code
2. Have better performance compare to VBA, since these are compiled code

In this simple scenario, does the choice of VB/VB.net makes significant
difference?
Is coding VB.net add-in anymore complicated than using VB6?

Tee