View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] EagleOne@discussions.microsoft.com is offline
external usenet poster
 
Posts: 391
Default Must VBA be manually converted to VB.NET (C++;C#) to create a DLL or Com Addin?

To both Rick & Pat

After downloading Visual Server 2010 beta, I have yet to actually attempt to compile to a DLL. This
I will do tomorrow.

That said, I understand that the VS 2008 issue of compiling only to a DLL for XL 2007, has been
overcome.

I love the interface DLL DLL Com Addin also the documentation seems great.

I'll post back tomorrow the plus's and minus's.

EagleOne

"Rick Rothstein" wrote:

While I haven't used any of the .NET products personally, it is my
understanding that the VB6 VB.NET Converter leaves a **lot** to be desired
(tending to leave lots of lines of code not converted thus requiring the
programmer to convert them by hand)... people who have dealt with it have
told me it is probably best to use your VB6 program as a guide and simply
rewrite the program in your VB.NET version from scratch (taking advantage of
the new constructs available in the VB.NET program... once you learn them,
that is<g).