O'Reilly logo

Special Edition Using Microsoft® Visual Basic® .NET by Jeff Spotts, Brian Siler

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required