Rob Bovey Bücher

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.

The definitive guide to developing applications with Microsoft Excel, this book is written by four authors who are Excel MVPs and run their own companies developing Excel-based applications.

You have learned the methods to the madness of Excel. Formulas and functions are friends instead of foes. Yet you know there's something missing that could make your job even easier. That "something" is efficient and effective data management. Managing Data with Excel is the only book on the market that focuses on just that. Learn how to efficiently move data, automate data storage and import data into worksheets and pivot tables. Case studies are included in each chapter to illustrate real-world applications of these functions. Invest your time in learning this now so that you can stop wasting your time figuring out how to work around problems.