* More than 400 task-oriented pages show intermediate-to-advanced users how to automate, customize, and integrate Excel using Visual Basic for Applications and VBA-based macros
* Crisp, two-color screen shots and succinct step-by-step instructions demonstrate how to create macros, add customized features to spreadsheets, and build powerful Excel-based applications
* Shows how to make macros "smart," create and customize VBA code, program Smart Documents, make Excel communicate efficiently with other applications, and more
* With VBA, users can buy Excel off the shelf and customize it to meet their specific business needs instead of building applications from scratch-saving users and businesses time and money
* All information is applicable to Excel versions 2000, 2002, and 2003
Reihe
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Illustrationen
Maße
Höhe: 23.1 cm
Breite: 20.5 cm
Dicke: 30 mm
Gewicht
ISBN-13
978-0-7645-7973-8 (9780764579738)
Schweitzer Klassifikation
Julia Kelly is a writer, teacher, and consultant for desktop applications, including Excel, Access, Word, Publisher, and Outlook. She's taught classroom courses in Excel at major corporations and Outlook courses on-line for several years, and has authored 17 book on Office applications. In addition, she develops Excel and Access applications for business clients.
PART I: CREATING SIMPLE MACROS.
1. Recording Simple Macros.
2. Running Macros.
3. Recording Complex Macros.
4. Simplifying and Protecting Macros.
PART II: EXPLORING THE VISUAL BASIC EDITOR.
5. Getting to Know the Visual Basic Editor.
6. Using the Visual Basic Editor.
7. Manipulating Modules and Projects.
PART III: MANIPULATING WORKBOOKS AND WORKSHEETS.
8. Writing Workbook Macros.
9. Creating Worksheet Macros.
10. Changing Worksheet Settings.
PART IV: WORKING WITH RANGES.
11. Selecting and Manipulating Ranges.
12. Formatting Ranges.
13. Entering Data and Formulas.
PART V: MAKING A MACRO SMART.
14. Setting Conditions.
15. Using Loops.
16. Fixing Errors.
PART VI: CREATING CHART AND PIVOTTABLE MACROS.
17. Writing Chart Macros.
18. Modifying Chart Macros.
19. Writing PivotTable Macros.
PART VII: USING FORMS AND CONTROLS.
20. Creating Worksheet Controls.
21. Creating Programmed Controls.
22. Controlling Macros and Events.
23. Polishing with Extra Macros.
