Warning: applications work together in amazing new ways that can save you time and effort, but OLE should also carry a warning label: "Work in Progress--Hard Hat Area." This Underground Guide gives you expert advice on how to get your money's worth without losing your data or your mind. Do you think VBA and DDE are government agencies? Are you convinced that OLE Automation involves those mechanical bulls in cowboy bars? Think again! These powerful technologies can let your use the applications in Microsoft (R) Office together to work better and faster than ever--or they can drive you completely around the bend. Lee Hudspeth and Timothy-James Lee give you inside information not found anywhere else, including shortcuts, warnings, and tips on finding (and squashing!) OLE's baddest bugs. Get the truth about OfficeLinks, the umbrella term for features that link, embed, edit-in-place, and draw-and-drop objects and Office-infinitum. Find out the difference between linking and embedding objects across applications and why you should care (Hint: read this chapter before you download that multimedia presentation onto the boss's laptop). Use Visual Basic for Applications and OLE Automation to set up your own Microsoft Office Puppet Government (tm) and make those formerly independent applications work together--whether they want to or not. Mouthwatering VBA source code galore! And many other amazing and little-known facts! Every page has something you can use immediately. This book is packed with advice, VBA source code, bug reports, workarounds, and the ding of nitty-gritty explanations that could come only from people who eat, sleep, and breathe Microsoft Office. Series Editor Woody Leonard and Addison-Wesley are proud to bring you the Underground Guides--fun books for serious computer users. 0201410354B04062001