Teach Yourself Excel Programming With Visual Basic for Applications in 21 Days

Microsoft Office, the largest installed base among the various office suites, has become a development platform in its own right. This guide shows how to use Visual Basic for Applications to automate daily activities and share data through programmed OLE communications between applications such as Microsoft Word, Microsoft Access, and Microsoft Excel.

Teach Yourself Excel Programming with Visual Basic for Applications in 21 Days covers programming in Excel 95. The authors dedicate most of the book to a tutorial on Visual Basic and, as a result, you can apply the lessons to programming other Office applications. Harris begins with a discussion of how to create Excel macros, a simple task that even new Word users can perform. He then shows you how to look at the Visual Basic code that defines the Word macro and build more sophisticated Visual Basic programs.