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