Thread: VBA and VSTO
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jos Vens[_2_] Jos Vens[_2_] is offline
external usenet poster
 
Posts: 134
Default VBA and VSTO

Hi,

since I have serious problems in VBA, I consider to migrate to VSTO. I have
some questions about that, in order of importance:

1. Is my code in VBA in a high level portable to the new platform
2. Can I compile the project to an executable stand-alone file (.exe) so I
am not dependent to what the user have installed of dll's
3. Does it work with all versions of Office (starting with 2000)

Thanks for your help.
Jos Vens

PS my big problem in VBA is the difference of the mso.dll (mso9.dll for
office 2000) of the different office versions, which causes a crash on
startup when I build up my menu-bar. Recompilation on the specific excel
version solves the problem, but then I have to maintain at least 3 versions
(2000, XP and 2003). Even subversions (Service Packs and minor upgrades
cause those commilation problems so I cannot keep that much versions).