Manipulating the COM Server from the Client Code

After you have an instance of an object from an automation server, manipulating the server (creating objects, setting properties, calling methods, and so forth) is accomplished by manipulating the object. In the following sections, you'll manipulate the new Excel object (by setting properties and calling methods), and in so doing you will be manipulating Excel itself.

Forcing Excel to Show Itself

When Excel is started using Automation, it's loaded but not shown. Keeping Excel hidden enables the developer to use Excel's functionality and then close it without the user knowing what happened. For instance, you could create an instance of an Excel object, perform a complicated formula to obtain a result, ...

Get Sams Teach Yourself Microsoft® Visual C#™ .NET in 24 Hours now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.