Increase your productivity and save time and effort with ExcelVBA
This unique book-and-DVD package prepares you to get more out ofExcel by using Visual Basic for Applications (VBA) to automate yourroutine or labor-intensive Excel tasks. Microsoft Excel MVP andauthor Tom Urtis walks through a series of lessons while theaccompanying DVD provides demos to complement each lesson. Urtistakes an in-depth look at how manual tasks in Excel can beprogrammed with VBA for greater speed, efficiency, and accuracy.You'll learn how to use VBA to manipulate Excel in ways you maynever have thought possible.
Excel VBA 24-Hour Trainer:
Introduces you to VBA and discusses topics including objectorientedprogramming, 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-definedfunctions
Shows you how to customize the look and feel of Excel withUserForms, Input Boxes, Message Boxes, and embedded controls
Examines advanced topics including class modules, add-ins, andretrieving external data with ADO and SQL
Demonstrates how to interact with other Office Applications fromExcel, including Word, Access®, PowerPoint®, andOutlook®
Wrox guides are crafted to make learning programming languagesand technologies easier than you think. Written by programmers forprogrammers, they provide a structured, tutorial format that willguide you through all the techniques involved.
On the DVD
Don't just learndo!
The lessons within the book are accompanied by an instructionaldemonstration 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
Interact with Office applications Word, Access, PowerPoint, andOutlook