{"product_id":"vba-and-macros-for-microsoft-office-excel-2007-book-bill-jelen-9780789736826","title":"VBA and Macros for Microsoft Office Excel 2007","description":"“In this day and age of ‘too much information and not enough time,’ the ability to get to the bottom line quickly and in a concise method is what excels companies to the top of their industry. The techniques in this book will allow you to do things you only dreamt of.”  —Jerry Kohl, president of Brighton Collectibles     Develop your Excel macro programming skills using VBA instantly with proven techniques     Automate Reports   Handle Errors   Master Pivot Tables   Produce Charts   Build User-Defined Functions   Migrate to Excel 2007   Query Web Data   Build Dialog Boxes   Use Data Visualizations   Automate Word        You are an expert in Excel, but the macro recorder doesn’t work and you can’t make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros. This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This 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.    Learn VBA syntax as easy-to-understand English Automate Excel’s power tools: Pivot Tables, Charts, Advanced Filters Save hours per week by automating redundant tasks Create applications built on top of Excel with custom dialog boxes Automatically produce hundreds of Excel reports in seconds Understand how changes in Excel 2007 impact your VBA macros  Introduction   1  1 Unleash the Power of Excel with VBA      7  2 This Sounds Like BASIC, So Why Doesn’t It Look Familiar?       29   3 Referring to Ranges 61   4 User-Defined Functions     75  5 Looping and Flow Control   101  6 R1C1-Style Formulas        121  7 What’s New in Excel 2007 and What's Changed  135  8 Create and Manipulate Names in VBA      143  9 Event Programming 155  10 UserForms--An Introduction       177  11 Creating Charts    197  12 Data Mining with Advanced Filter          249  13 Using VBA to Create Pivot Tables         281  14 Excel Power         337  15 Data Visualizations and Conditional Formatting  373  16 Reading from and Writing to the Web              393  17 XML in Excel 2007 413  18 Automating Word  421  19 Arrays       441  20 Text File Processing    449  21 Using Access as a Back End to Enhance Multi-User Access to Data   461  22 Creating Classes, Records, and Collections       477  23 Advanced UserForm Techniques  493  24 Windows Application Programming Interface (API)       517  25 Handling Errors     529  26 Customizing the Ribbon to Run Macros   543  27 Creating Add-Ins  569  Index  577","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49640051048721,"sku":"GOR002126610","price":6.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50590947180817,"sku":"CIN0789736829VG","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789736829.jpg?v=1751446360","url":"https:\/\/www.worldofbooks.com\/en-gb\/products\/vba-and-macros-for-microsoft-office-excel-2007-book-bill-jelen-9780789736826","provider":"World of Books ","version":"1.0","type":"link"}