Remote-Controlling Microsoft Excel
The Microsoft Excel object library, which is installed on a PC whenever Excel is installed, includes a group of objects that let applications control the Excel application behind the scenes. By leveraging this background process, you can create a Visual Basic program that begins an Excel session and works with an Excel workbook just as if a user were sitting at the keyboard and using Excel normally.
As you can see, the Excel object functionality is exposed as a Component Object Model (COM) component; however, Visual Basic .NET will be able to create a .NET platform bridge to Excel’s COM functionality.
Note
In order to use these techniques to interact with Microsoft Excel, you must have Excel 2000 or later installed ...
Get Special Edition Using Microsoft® Visual Basic® .NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
