Application #93. Automate Office via COM Interop
This sample application shows you how to automate Microsoft Office from .NET.
Application #7: Object-Oriented Features
Not every application can be all things to all people, so sometimes you’ll find that you need the help of another program to accomplish your goals. For example, you might have some raw numbers you’re processing in your Microsoft Visual Basic .NET application, and you decide that you need some sophisticated statistical computations done on the data. One way to meet the need is to use an Excel workbook to process the numbers.
However, you don’t have to click a shortcut to call up Excel because, like all the major Microsoft Office programs, Excel ...