Re: VBA and VSTO

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" <jos.vens@xxxxxxxxxxxxxx> wrote in message
news:ubE1QEYVGHA.5020@xxxxxxxxxxxxxxxxxxxxxxx
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).



.

Relevant Pages

  • Re: VBA and VSTO
    ... VB.NET is vastly larger and more complicated than VBA. ... Microsoft MVP - Excel ... file (.exe) so I am not dependent to what the user have ...
    (microsoft.public.excel.programming)
  • Re: C# and native resources
    ... For instance when you run mt on a X86 platform, ... following assemblyIdentity element: ... Extracting the manifest from my finished EXE, ... the manifest fragment that I fed into mt when the EXE was built (the ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Cross Platform Development
    ... On GNU/Linux, applications can and do ... widely-used languages on the platform. ... Would you really be happy to be completely dependent ... If the problem is that you want to write closed-source code, ...
    (uk.comp.os.linux)
  • Re: Linking with specific dll in evc4
    ... Have you looked at the options on the Link tab in the project ... If you are using a single workspace, simply making the EXE project dependent ... Select EXE as the project to modify, check the DLL project as ...
    (microsoft.public.windowsce.embedded.vc)
  • Re: WindowsForm Application in C#.NET
    ... you can find out all the dependent assemblies of your .NET ... exe, then copy those dependent dlls into your application directory, in ... you need to do something on the registry. ... Now you can copy the generated package to machines w/o .NET Framework, ...
    (microsoft.public.dotnet.framework)