Geek Answers Handbook

MS Word Extensibility: VBA Macro vs. .Net VSTO?

One of my clients asked us to develop a "VBA macro." However, in 2010 it seems strange to me that I am still using such an outdated language, and I am thinking of trying to convince the client to use VSTO dev. However, since I'm new to both worlds, I need help filling out the pro / cons page to be able to argue for this.

Of course, the answer cannot come without an actual requirement, let me try to resume:

Target: Word 2003/2007 (but I suspect 2010 as not yet known requirement) change confirmed 2010

An external publishing system requires the input of .doc . In the .doc file , certain styles should be applied: "Custom Title 1", "Custom Title 2", etc.

A user can create documents using Word using two possible methods:

  • Launch a new document using the .dot file deployed on your computer.
  • Convert any existing document to the target template

Users can “apply” styles “simply” (simple interface): context menu, style menu, custom scope, etc.

Currently, I see the following pro / cons:

  • Vba

    • Pros:
      • quick and dirty development (quick part of the sentence)
      • The client already has some kind of production macro
    • Minuses:
      • hard to find a qualified developer
      • ( )

  • VSTO

    • :
      • .Net(, , , ..).
      • ( , )
      • WPF.
      • Visual Studio : , ..
    • :
      • .NET- (, ) VSTO
      • ( )
+5
5

, .

, , VBA. :

:

  • , , #, VBA ( ).
  • : , , .

:

  • .
    • Word " " " ". , -. " " .
    • NSIS script, . VSTO (clickonce?) .
  • ! 1, 0, , - . , - ( ).
  • (, .dot, . .dot )
  • VBA

:

#, / .

+2

.NET, VBA:

VBA

  • :
    • Office
    • ( ) -
  • :
    • ,
    • ( ) - . , :
      • VBA /
    • .Net(, ) , (, CONS VSTO?)

, - , , VBA, ( ).

+3

Excel VBA.

VBA pro: VSTO VBA - , , # - , , . VBA , , VSTO . ( - .)

, -, .

VBA con: VBA - , , , , . " ", , , , VBA hackjobs , - . VBA , , , , .

, - VBA , . , , VBA , " VBA". VBA , "" .

( Perl , , - , - , , - .)

+1

Excel. Office, .

+1

: : CONS: Addins 2007, 2007, 2010 2013. , Addins Word Excel , 2007, 2010 2013 . PLZ , , , Single Addins .

0

More articles:


All Articles