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