Product Information
There are an estimated 400 million Excel users. Many are Excel power users, but far fewer have figured out how to effectively use Excel VBA. This book is designed to get Excel users up and running with Excel VBA. Many Excel users are frustrated when they record their own macros with the macro recorder, only to discover that the macros won't work exactly right the next day. This book explains the shortcomings of the macro recorder, but also covers how to take the recorded code and turn it into something really useful. Once you are over that hurdle, the book explains how to understand the object- oriented Visual Basic for Applications Language. After those fundamentals, the book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you. *Understand why the macro recorder doesn't work! *Learn how to convert recorded code into something useful *VBA syntax explained in easy-to-understand English *Automate Excel's power tools: Pivot Tables, Charts, Advanced Filters *Save hours per week by automating redundant tasks *Dramatically increase your efficiency with ExcelProduct Identifiers
PublisherPearson Education (Us)
ISBN-139780789731296
eBay Product ID (ePID)86731440
Product Key Features
Number of Pages576 Pages
Publication NameVba and Macros for Microsoft Excel
LanguageEnglish
SubjectComputer Science
Publication Year2004
TypeTextbook
AuthorTracy Syrstad, Bill Jelen
FormatPaperback
Dimensions
Item Height186 mm
Item Weight942 g
Additional Product Features
Country/Region of ManufactureUnited States
Title_AuthorBill Jelen, Tracy Syrstad