{"product_id":"9780789736826","title":"VBA and Macros for Microsoft Office Excel 2007","description":"\u003cp\u003e“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.”\u003c\/p\u003e\u003cp\u003e—Jerry Kohl, president of Brighton Collectibles\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eDevelop your Excel macro programming skills using VBA instantly with proven techniques\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eAutomate Reports \u003c\/p\u003e\u003cp\u003eHandle Errors \u003c\/p\u003e\u003cp\u003eMaster Pivot Tables \u003c\/p\u003e\u003cp\u003eProduce Charts \u003c\/p\u003e\u003cp\u003eBuild User-Defined Functions \u003c\/p\u003e\u003cp\u003eMigrate to Excel 2007 \u003c\/p\u003e\u003cp\u003eQuery Web Data \u003c\/p\u003e\u003cp\u003eBuild Dialog Boxes \u003c\/p\u003e\u003cp\u003eUse Data Visualizations \u003c\/p\u003e\u003cp\u003eAutomate Word\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eYou 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.\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003e Learn VBA syntax as easy-to-understand English \u003c\/li\u003e\n\u003cli\u003e Automate Excel’s power tools: Pivot Tables, Charts, Advanced Filters \u003c\/li\u003e\n\u003cli\u003e Save hours per week by automating redundant tasks \u003c\/li\u003e\n\u003cli\u003e Create applications built on top of Excel with custom dialog boxes \u003c\/li\u003e\n\u003cli\u003e Automatically produce hundreds of Excel reports in seconds \u003c\/li\u003e\n\u003cli\u003e Understand how changes in Excel 2007 impact your VBA macros \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eIntroduction 1\u003c\/p\u003e\u003cp\u003e1 Unleash the Power of Excel with VBA 7\u003c\/p\u003e\u003cp\u003e2 This Sounds Like BASIC, So Why Doesn’t It Look Familiar? 29 \u003c\/p\u003e\u003cp\u003e3 Referring to Ranges 61 \u003c\/p\u003e\u003cp\u003e4 User-Defined Functions 75\u003c\/p\u003e\u003cp\u003e5 Looping and Flow Control 101\u003c\/p\u003e\u003cp\u003e6 R1C1-Style Formulas 121\u003c\/p\u003e\u003cp\u003e7 What’s New in Excel 2007 and What's Changed 135\u003c\/p\u003e\u003cp\u003e8 Create and Manipulate Names in VBA 143\u003c\/p\u003e\u003cp\u003e9 Event Programming 155\u003c\/p\u003e\u003cp\u003e10 UserForms--An Introduction 177\u003c\/p\u003e\u003cp\u003e11 Creating Charts 197\u003c\/p\u003e\u003cp\u003e12 Data Mining with Advanced Filter 249\u003c\/p\u003e\u003cp\u003e13 Using VBA to Create Pivot Tables 281\u003c\/p\u003e\u003cp\u003e14 Excel Power 337\u003c\/p\u003e\u003cp\u003e15 Data Visualizations and Conditional Formatting 373\u003c\/p\u003e\u003cp\u003e16 Reading from and Writing to the Web 393\u003c\/p\u003e\u003cp\u003e17 XML in Excel 2007 413\u003c\/p\u003e\u003cp\u003e18 Automating Word 421\u003c\/p\u003e\u003cp\u003e19 Arrays 441\u003c\/p\u003e\u003cp\u003e20 Text File Processing 449\u003c\/p\u003e\u003cp\u003e21 Using Access as a Back End to Enhance Multi-User Access to Data 461\u003c\/p\u003e\u003cp\u003e22 Creating Classes, Records, and Collections 477\u003c\/p\u003e\u003cp\u003e23 Advanced UserForm Techniques 493\u003c\/p\u003e\u003cp\u003e24 Windows Application Programming Interface (API) 517\u003c\/p\u003e\u003cp\u003e25 Handling Errors 529\u003c\/p\u003e\u003cp\u003e26 Customizing the Ribbon to Run Macros 543\u003c\/p\u003e\u003cp\u003e27 Creating Add-Ins 569\u003c\/p\u003e\u003cp\u003eIndex 577\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e","brand":"Que","offers":[{"title":"Default Title","offer_id":47015942586608,"sku":"9780789736826","price":39.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780789736826_p0.jpg?v=1763806703","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780789736826","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}