The Underground Guide to Microsoft Office, Ole, and Vba

The insider's guide to Microsoft applications tells users what works together and what does not, covers OLE theory and creating compound documents, and provides an introduction to programming in VBA and the basics of OLE Automation. Original. (Intermediate).

The Underground Guide to Microsoft Office, OLE, and VBA offers a sophisticated discussion of Office programming and the technologies that make it possible. Unfortunately, the book covers Office 4.x, which preceded Office 95, rendering much of the material obsolete. Nonetheless, Hudspeth and Lee describe OLE Automation, OfficeLinks, and Dynamic Data Exchange (DDE) in great detail and list dozens of low-level OLE and DDE bugs. While it won't provide you with the most up-to-date information, having this technophilosophical background is a prerequisite to becoming a great programmer.