VBA and Macros for Microsoft Office Excel 2007 (Business Solutions) Book

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..."Read More

Visit Cheapest Shop from£35.24 | RRP: £28.99
* Excludes Voucher Code Discount Also available Used from £3.71
  • Product 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

  • 0789736829
  • 9780789736826
  • Bill Jelen, Tracy Syrstad
  • 9 August 2007
  • QUE
  • Paperback (Book)
  • 624
  • 1

Would you like your name to appear with the review?

We will post your book review within a day or so as long as it meets our guidelines and terms and conditions. All reviews submitted become the licensed property of www.find-book.co.uk as written in our terms and conditions. None of your personal details will be passed on to any other third party.

All form fields are required.