VBA & Macros For Micorosoft Office Excel 2007
Broschiertes Buch

VBA & Macros For Micorosoft Office Excel 2007

Versandkostenfrei!
Nicht lieferbar
This book will dramatically increase white collar productivity. Given the current state of MIS departments, this reader is probably stuck in a user department and can't get the reports they need in a timely manner. They've taken matters into their own hands, importing raw data daily and performing time-consuming manipulations using Excel's power tools. We teach them how to automate these processes, dramatically saving hours of time. a) The book is written from the perspective of Excel power users who are trying to get up the VBA learning curve. The authors take the reader up those painful initial steps of the learning curve and by chapter 3, the reader will understand why their attempts to use the macro recorder have failed and have the confidence that Bill and Tracy will solve their problems. b) There are generations of readers who have only learned procedural languages such as COBOL or BASIC. These novice programmers are confused by the seemingly senseless syntax of object oriented languages such as VBA. In very simple to understand language, the authors explain what is going on and why. Chapter 2 is destined to become the greatest introduction to Object Oriented Programming for the common person ever written. c) Even if you've never programmed before, this book will take you up the learning curve to enable you to automate common tasks in Microsoft Excel. 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

Backcover
"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

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