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.
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
Excel VBA 24-Hour Trainer - At our site you can freely choose the books that you love and read it, but did you know that in order to write the book so interesting and useful to the reader, the author takes lots of energy and enthusiasm for it, so you stop the download and give a small amount to contribute to support the author, can help them write many more great books for you. Thanks you very much.
