Cargando…
Excel macros for dummies /
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 kno...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[Place of publication not identified] :
Wiley,
[2015]
|
| Colección: | --For dummies.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 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