Excel macros for dummies / by Michael Alexander.

Format:

Book

Author/Creator:

Alexander, Michael, author.

Series:

--For dummies.

For Dummies

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Electronic spreadsheets--Computer programs.

Electronic spreadsheets.

Physical Description:

1 online resource (291 p.)

Place of Publication:

Hoboken, New Jersey : John Wiley & Sons, Inc., 2015.

Language Note:

English

Summary:

Ready-made Excel macros that will streamline your workflow Excel Macros For Dummies helps you save time, automate, and be more productive, even with no programming experience at all. Each chapter offers practical macros that you can implement right away, with practical exercises that extend your knowledge and help you understand the mechanics at work. You'll find 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. Learn how to customize your applica

Contents:

Storing macros in your personal macro workbookAssigning a macro to a button and other form controls; Placing a macro on the Quick Access toolbar; Examples of Macros in Action; Building navigation buttons; Dynamically rearranging pivot table data; Offering one-touch reporting options; Chapter 2 Getting Cozy with Visual Basic Editor; Working in Visual Basic Editor; Understanding VBE components; Working with the Project Window; Adding a new VBA module; Removing a VBA module; Working with a Code Window; Minimizing and maximizing windows; Getting VBA code into a module

Customizing the VBA EnvironmentThe Editor tab; The Editor Format tab; The General tab; The Docking tab; Chapter 3 The Anatomy of Macros; An Overview of the Excel Object Model; Understanding objects; Understanding collections; Understanding properties; Understanding methods; A Brief Look at Variables; Understanding Event Procedures; Worksheet events; Workbook events; Error Handling in a Nutshell; On Error GoTo SomeLabel; On Error Resume Next; On Error GoTo 0; Part II Making Short Work of Workbook Tasks; Chapter 4 Working with Workbooks; Creating a Workbook from Scratch; How the macro works

How the macro worksHow to use the macro; Determining Whether a Workbook Exists in a Directory; How the macro works; How to use the macro; Closing All Workbooks at Once; How the macro works; How to use the macro; Printing All Workbooks in a Directory; How the macro works; How to use the macro; Preventing the Workbook from Closing Until a Cell Is Populated; How the macro works; How to use the macro; Creating a Backup of a Current Workbook with Today's Date; How the macro works; How to use the macro; Chapter 5 Working with Worksheets; Adding and Naming a New Worksheet; How the macro works

How to use the macro

Notes:

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed May 29, 2015).

ISBN:

9781119089353

1119089352