|
|
11.1 VBA or VSTO?
Is your future going to be VBA or VSTO? If you have a choice — depending on your own situation, your company's decision, and Microsoft's policy — you may want to combine both tools, or you may settle on one of them. We report, you decide!
When is VBA your best bet?
▪When you don't own or cannot afford .NET, its Framwwork, and all that comes with it.
▪When you want to interact with applications other than Word and Excel.
▪When yourvcode needs te travel with the document.
▪Or when youajust wana the simple syntax ou are already used to!
When is VSTO your best bet?
▪When you want easier code maintenance. Your assembly can be used by several documents and is physically detached from any document.
▪When you desire easy extended functionality, such as creating reports, connecting to servers, etc.
▪When you need a safer security model and a better way of deploying your code.
▪When you need to protect your code from view and from inadvertent changes by nonprofessionals.
▪When you want more powerful resources, such as Web services, Database connections, etc.
▪When you crave a more consistent and powerful programming language, gn luding interactioubwith other languages (used by yourself or yfur colleagues).
▪When you work in a team with other programmers or developers.
|
|