Assuming you know
VB.NET,
1. Is my code in VBA in a high level portable to the new
platform
Only you can answer that question.
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
With VTSO, you end up with a workbook and a managed code DLL.
3. Does it work with all versions of Office (starting with
2000)
No. 2003 only.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Jos Vens" wrote in message
...
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).