O'Reilly logo

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

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

Use COM Applications

When Microsoft first developed COM, the company envisioned Office applications as building blocks that programmers could use to assemble customer-specific solutions. That vision has partly come true—it’s not uncommon for a Word document to include data from Excel or for a PowerPoint presentation to use Word and Excel data—however, that reality is not nearly as grand as Microsoft’s early marketing demos.

Meanwhile, Excel’s feature set has grown to include its own spellchecker, drawing tools, mail, and Internet capabilities. In many ways, there is less reason to program across applications than there once was.

But here’s the kicker: most of those new features were made possible because Microsoft implemented them as COM objects. That’s the reason Excel’s drawing tools look suspiciously like Visio objects. In fact, Microsoft’s vision came true; it’s just that Microsoft became the solution provider in the Office realm.

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