Re: VBA and VSTO

Tech-Archive recommends: Fix windows errors by optimizing your registry

Another suggestion: can my project be too big? it is now more than 5 mb?

Jos


"Niek Otten" <nicolaus@xxxxxxxxx> schreef in bericht
news:OUtDSkcVGHA.5580@xxxxxxxxxxxxxxxxxxxxxxx
I don't think it is wise to take refuge in a new and unknown tool because
the old one causes you problems. I really think you should try to find out
what's wrong with the present application. Only if you find out that there
is something that VBA can't do correctly and VSTO can, you could consider
to migrate.
But I don't think that will happen; too many people manage get things
right in VBA, albeit with some trouble sometimes.
I don't know what you mean exactly with "I've built a compiler " but it
makes me shiver. Don't! Use standard and proven tools whenever you can!

Just my opinion.....

--
Kind regards,

Niek Otten


"Jos Vens" <jos.vens@xxxxxxxxxxxxxx> wrote in message
news:uvxoCCcVGHA.5900@xxxxxxxxxxxxxxxxxxxxxxx
I know,

but if VSTO is stable, I can convince my customers to migrate to 2003,
now it's a mess: my excel application crashes on almost every machine,
unless it is upgraded to the right version (like for XP is it
10.6789.6735 SP3). All other versions are crashing, unless I recompile.
I've built a compiler (I use the sendkeys method to unlock the project
etc etc... It worked, but on 2003 I couldn't save it anymore - an error
on saving appeared for an unknown reason).

Thanks for all your suggestions!
Jos Vens



"Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:eIFbDYbVGHA.2444@xxxxxxxxxxxxxxxxxxxxxxx
If you are deploying to Excel 2000 and Xp as well as 2003, VB.Net isn't
really an option anyway.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jos Vens" <jos.vens@xxxxxxxxxxxxxx> wrote in message
news:O1B0EUbVGHA.736@xxxxxxxxxxxxxxxxxxxxxxx
Hi Chip,

I mean, I developped in VBA, and I don't want to spend to much time to
set
my code in vb.net. Is the language comparable or do I have to learn a
lot
(and debug a lot) to get my code back in vb?

I never used VB.NET! I assume you mean I cannot copy and paste my code
from
vba to vb.net.

Jos

"Chip Pearson" <chip@xxxxxxxxxxxx> schreef in bericht
news:uuJmpPYVGHA.1728@xxxxxxxxxxxxxxxxxxxxxxx
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
    ... I tried the code cleaner, ... Jos Vens ... I mean, I developped in VBA, and I don't want to spend to much time to ... since I have serious problems in VBA, I consider to migrate to VSTO. ...
    (microsoft.public.excel.programming)
  • Re: VBA and VSTO
    ... Jos Vens ... I mean, I developped in VBA, and I don't want to spend to much time to ... Microsoft MVP - Excel ... since I have serious problems in VBA, I consider to migrate to VSTO. ...
    (microsoft.public.excel.programming)
  • Re: VBA and VSTO
    ... Only if you find out that there is something that VBA can't do correctly and VSTO can, ... But I don't think that will happen; too many people manage get things right in VBA, ... I don't know what you mean exactly with "I've built a compiler " but it makes me shiver. ... > Microsoft MVP - Excel ...
    (microsoft.public.excel.programming)
  • Re: VBA and VSTO
    ... Moving code to VB6 can't be simpler and I am sure that is the best way to go. ... .xla add-in at 3.9 Mb with all the non-code bits completely stripped out. ... But I don't think that will happen; too many people manage get things right in VBA, ... I don't know what you mean exactly with "I've built a compiler " but it makes me shiver. ...
    (microsoft.public.excel.programming)
  • Re: Feasible to do a database project in MS Access + PL/1?
    ... IBM's compiler has no native COM support, meaning there is neither a MIDL ... There are none for PL/I. ... Access does not rely on VBA. ...
    (comp.lang.pl1)