Excel Macros For Dummies

Save time and be way more productive with Microsoft Excel macros

Looking for ready-made Excel macros that will streamline your workflow? Look no further! Excel Macros For Dummies, 2nd Edition helps you save time, automate, and be more productive-even with no programming experience at all. Each chapter offers macros you can implement right away, with practical exercises that extend your knowledge and help you understand the mechanics at work. You'll find over 70 of the most effective Excel macros for solving common problems and explanations of why and where to use each one-plus invaluable guidance and step-by-step instruction for applying them effectively.

Microsoft Excel is the world's leading spreadsheet application, and it supports VBA macros that allow you to customize the program and automate many common tasks. In no time, you'll learn how to customize your applications to look and work exactly the way you want them to, with simple, friendly walk-throughs that directly apply to real-world tasks. Follow it through from start to finish, or quickly look up problems as they occur. It's the perfect desk reference for all of your Microsoft Excel macros needs!

• Immediately implement the given Excel macros

• Work with workbooks, worksheets, and ranges

• Clean data, automate reporting, and send email from Excel

• Streamline your workflow

If you have an Excel problem, there's a macro to solve it-and now, you don't need to be a programmer to customize it for your own use!.

Autorentext

Michael Alexander is a Microsoft Certified Application Developer (MCAD) who has been named a Microsoft MVP for his ongoing contributions to the Excel community. He has more than 15 years of experience in consulting and developing Office solutions, and shares basic Access and Excel tips on his free tutorial site, www.datapigtechnologies.com.

Zusammenfassung
Save time and be way more productive with Microsoft Excel macros Looking for ready-made Excel macros that will streamline your workflow? Look no further! Excel Macros For Dummies, 2nd Edition helps you save time, automate, and be more productiveeven with no programming experience at all. Each chapter offers macros you can implement right away, with practical exercises that extend your knowledge and help you understand the mechanics at work. You'll find over 70 of the most effective Excel macros for solving common problems and explanations of why and where to use each oneplus invaluable guidance and step-by-step instruction for applying them effectively. Microsoft Excel is the world's leading spreadsheet application, and it supports VBA macros that allow you to customize the program and automate many common tasks. In no time, you'll learn how to customize your applications to look and work exactly the way you want them to, with simple, friendly walk-throughs that directly apply to real-world tasks. Follow it through from start to finish, or quickly look up problems as they occur. It's the perfect desk reference for all of your Microsoft Excel macros needs!

• Immediately implement the given Excel macros
• Work with workbooks, worksheets, and ranges
• Clean data, automate reporting, and send email from Excel
• Streamline your workflow If you have an Excel problem, there's a macro to solve itand now, you don't need to be a programmer to customize it for your own use!.

Inhalt
Introduction 1

About This Book 2

Foolish Assumptions 2

Icons Used in This Book 3

Beyond the Book 3

Where to Go from Here 4

Part 1: Holy Macro Batman! 7

Chapter 1: Macro Fundamentals 9

Why Use a Macro? 9

Macro Recording Basics 10

Examining the macro 12

Testing the macro 13

Editing the macro 13

Comparing Absolute and Relative Macro Recording 14

Recording macros with absolute references 14

Recording macros with relative references 17

Other Macro Recording Concepts 19

Macro-enabled file extensions 19

Macro security in Excel 2010 19

Trusted locations 20

Storing macros in your Personal Macro Workbook 21

Assigning a macro to a button and other form controls 22

Placing a macro on the Quick Access Toolbar 23

Examples of Macros in Action 24

Building navigation buttons 24

Dynamically rearranging PivotTable data 25

Offering one-touch reporting options 27

Chapter 2: Getting Cozy with the Visual Basic Editor 29

Working in the Visual Basic Editor 29

The VBE menu bar 30

The VBE toolbar 31

The Project window 31

The Code window 31

The Immediate window 31

Working with the Project Window 32

Adding a new VBA module 32

Removing a VBA module 33

Working with a Code Window 34

Minimizing and maximizing windows 34

Getting VBA code into a module 35

Customizing the VBA Environment 37

The Editor tab 38

The Auto Syntax Check option 38

The Require Variable Declaration option 38

The Editor Format tab 40

The General tab 41

The Docking tab 42

Chapter 3: The Anatomy of Macros 43

A Brief Overview of the Excel Object Model 43

Understanding objects 44

Understanding collections 45

Understanding properties 45

Understanding methods 46

A Brief Look at Variables 46

The common variable types 47

Understanding Event Procedures 49

Worksheet events 49

Workbook events 51

Error Handling in a Nutshell 53

On Error GoTo SomeLabel 53

On Error Resume Next 54

On Error GoTo 0 55

Part 2: Making Short Work of Workbook Tasks 57

Chapter 4: Working with Workbooks 59

Creating a New Workbook from Scratch 60

How it works 60

How to use it 61

Saving a Workbook when a Particular Cell Is Changed 61

How it works 62

How to use it 63

Saving a Workbook before Closing 64

How it works 64

How to use it 65

Protecting a Worksheet on Workbook Close 66

How it works 66

How to use it 67

Unprotecting a Worksheet on Workbook Open 68

How it works 68

How to use it 68

Opening a Workbook to a Specific Tab 69

How it works 69

How to use it 70

Opening a Specific Workbook Defined by the User 70

How it works 71

How to use it 72

Determining Whether a Workbook Is Already Open 72

How it works 73

How to use it 75

Determining Whether a Workbook Exists in a Directory 75

How it works 76

How to use it 77

Closing All Workbooks at Once 77

How it works 77

How to use it 78

Printing All Workbooks in a Directory 78

How it works 79

How to use it 80

Preventing the Workbook from Closing Until a Cell Is Populated 80 How it works 80</p...