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" wrote:

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