Excel 2002 VBA

This book focuses on VBA, the programming language for Microsoft Office, particularly Excel, enabling users to automate tasks and develop applications. Excel 2002 marks a significant upgrade, enhancing Office's web-enabled capabilities with features like SmartTags and XML support. Building on the successful Excel 2000 VBA Programmer's Reference, this updated edition is crafted by Excel MVPs who actively support the VBA programming community. The content is structured in three parts: the first introduces Excel and VBA, including a primer on VBA. The second part delves into practical discussions of Excel VBA features, providing real-world examples and addressing common questions. The final section serves as a comprehensive reference for the Excel Object Model, Visual Basic Editor (VBE), and Common Office Object Models. Readers will learn about the entire Excel Object Model, working with PivotTables, accessing data sources via ADO, programming in the VBE, and exploring new features in Excel 2002. The book also includes expanded references for earlier Excel versions (97, 2000, and 2002). It caters to both beginner and intermediate programmers while offering advanced insights for experienced developers in later chapters and the reference section.