Excel Macros For Dummies

(0) Erste Bewertung abgeben
CHF 28.00
Download steht sofort bereit
E-Book (epub)
Informationen zu E-Books
E-Books eignen sich auch für mobile Geräte (sehen Sie dazu die Anleitungen).
E-Books von Ex Libris sind mit Adobe DRM kopiergeschützt: Erfahren Sie mehr.
Weitere Informationen finden Sie hier.

Beschreibung

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!.

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.

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.

Klappentext

  • Save time and be more productive with Excel macros
  • Understand how macros work and how to customize them
  • Includes over 70 Excel macros for immediate use

Save time with these ready-made Excel macros!

If you have an Excel problem, there's a macro to solve it. This book provides you with a whopping 70+ of the most effective ones, ready to go! You'll find explanations and instructions for applying macros, as well as tips on how to customize them to automate lots of common tasks. Not a programmer? Not necessary! You have free web access to all the code necessary and simple directions for tailoring VBA macros to your needs. Start streamlining your workflow today!

Inside

  • Macro fundamentals overview
  • Getting started with VBA
  • Creating and building workbooks
  • Cleaning up your data
  • Automating your reports
  • Sending emails from Excel
  • Retrieving external data sources


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

Mehr anzeigen

Produktinformationen

Titel
Excel Macros For Dummies
Autor
EAN
9781119369271
ISBN
978-1-119-36927-1
Format
E-Book (epub)
Herausgeber
For Dummies
Genre
Anwendungs-Software
Veröffentlichung
16.02.2017
Digitaler Kopierschutz
Adobe-DRM
Dateigrösse
2.86 MB
Anzahl Seiten
312
Jahr
2017
Untertitel
Englisch
Mehr anzeigen
Andere Kunden kauften auch