Excel 2003 VBA Programming
(Sprache: Englisch)
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...
Crisp, two-color screen shots and succinct step-by-step instructions demonstrate...
Leider schon ausverkauft
versandkostenfrei
Buch
27.90 €
Produktdetails
Produktinformationen zu „Excel 2003 VBA Programming “
Klappentext zu „Excel 2003 VBA Programming “
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.
Inhaltsverzeichnis zu „Excel 2003 VBA Programming “
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.
Autoren-Porträt von Julia Kelly
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.
Bibliographische Angaben
- Autor: Julia Kelly
- 2005, 448 Seiten, Kartoniert (TB), Englisch
- Verlag: Wiley & Sons
- ISBN-10: 0764579738
- ISBN-13: 9780764579738
Sprache:
Englisch
Kommentar zu "Excel 2003 VBA Programming"
0 Gebrauchte Artikel zu „Excel 2003 VBA Programming“
Zustand | Preis | Porto | Zahlung | Verkäufer | Rating |
---|
Schreiben Sie einen Kommentar zu "Excel 2003 VBA Programming".
Kommentar verfassen