View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keith Willshaw Keith Willshaw is offline
external usenet poster
 
Posts: 170
Default Can an Excel macro be converted into a VBdotnet Windows application?


"Mirsten Choiple" wrote in message
...
Can an Excel macro be converted into a VBdotnet Windows
application?

Thanks in advance,

Mirsten Choiple


The routines - yes

The code modules can be largely just imported but you
should note there are some changes between VBA and
..Net

For example there are no variants in .net and the handling of
arrays is somewhat different.

Importing forms is also possible but you are better off rebuilding them
using the .net tools.

The actual Spreadsheet functionallity still requires Excel
you can build a compiled .net addin to replace the VBA routines.

Keith