Increase your productivity and save time and effort with Excel VBA This unique book-and-DVD package prepares you to get more out of Excel by using Visual Basic for Applications (VBA) to automate your routine or labor-intensive Excel tasks. Microsoft Excel MVP and author Tom Urtis walks through a series of lessons while the accompanying DVD provides demos to complement each lesson. Urtis takes an in-depth look at how manual tasks in Excel can be programmed with VBA for greater speed, efficiency, and accuracy. You'll learn how to use VBA to manipulate Excel in ways you may never have thought possible. Excel VBA 24-Hour Trainer: Introduces you to VBA and discusses topics including object oriented programming, variable declaration, objects and collections, and arrays Teaches you how to write your own macros for programming loops, events, charts, pivot tables and pivot charts, and user-defined functions Shows you how to customize the look and feel of Excel with User Forms, Input Boxes, Message Boxes, and embedded controls Examines advanced topics including class modules, add-ins, and retrieving external data with ADO and SQL Demonstrates how to interact with other Office Applications from Excel, including Word, Access(r), PowerPoint(r), and Outlook(r) Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved. On the DVD Don't just learn--do! The lessons within the book are accompanied by an instructional demonstration on the DVD. Write your own macros Make decisions with VBA Repeat actions with loops Automate procedures with worksheet and workbook events Work with arrays Create class modules Program charts and pivot tables Create add-ins Interact with Office applications Word, Access, PowerPoint, and Outlook Manage external data Debug your code Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.
Table of contents
Section I: Understanding the BASICs Lesson 1. Introducing VBA Lesson 2. Getting Started with Macros Lesson 3. Introducing the Visual Basic Editor Lesson 4. Working in the VBE Section II: Diving Deeper into VBA Lesson 5. Object-oriented Programming — An Overview Lesson 6. Variables, Data Types, and Constants Lesson 7. Understanding Objects and Collections Lesson 8. Making Decisions with VBA Section III: Beyond the Macro Recorder. Writing Your Own Code Lesson 9. Repeating Actions with Loops Lesson 10. Working with Arrays Lesson 11. Automating Procedures with Worksheet Events Lesson 12. Automating Procedures with Workbook Events Lesson 13. Using Embedded Controls Lesson 14. Programming Charts Lesson 15. Programming PivotTables and PivotCharts Lesson 16. User Defined Functions Lesson 17. Debugging Your Code Section IV: Advanced Programming Techniques Lesson 18. Creating UserForms Lesson 19. UserForm Controls and Their Functions Lesson 20. Advanced UserForms Lesson 21. Class Modules Lesson 22. Add-Ins Lesson 23. Managing External Data Lesson 24. Data Access with ActiveX Data Objects Lesson 25. Not Gone, Not Forgotten Section V: Interacting with Other Office Applications Lesson 26. Overview of Office Automation from Excel Lesson 27. Working with Word from Excel Lesson 28. Working with Outlook from Excel Lesson 29. Working with Access from Excel Lesson 30. Working with PowerPoint from Excel
About The Author
Tom Urtis is a Microsoft Office developer and programming expert with over 20 years of experience in developing customized Office programs with Visual Basic for Applications (VBA) and Application Programming Interface (API). In 2000 Tom founded Atlas Programming Management (www.atlaspm.com), an Office solutions company in Silicon Valley that specializes in Excel to provide consulting, project development, training, and support for a diverse international clientele. As an Excel trainer, Tom created the Excel Aptitude Test (XAT, www.xatcorp.com), which measures knowledge of Excel for a customized training curriculum based on the test score.
Tom is co-author of Holy Macro! It's 2,500 Excel VBA Examples, and he has served as a technical editor and consultant for other Excel books and training materials. Tom received the Most Valuable Professional award for Excel from Microsoft in 2008, and it has been renewed each year thereafter in recognition of his Excel skills and contributions to the Excel community. Tom is one of some 100 Excel experts worldwide who hold the Excel MVP award.
A native of New York state, Tom is a graduate of Michigan State University, and has lived and worked in the San Francisco Bay Area for 30 years. Tom is an avid sports fan and collector of rare sports memorabilia, and he enjoys the outdoor life that California offers. He can be reached by email, at [email protected].