| Introduction |
|
1 | (4) |
| Part I: Introducing VBA, the Common Language |
|
5 | (42) |
|
Chapter 1: Welcome to Office 97 |
|
|
7 | (4) |
|
Chapter 2: What's This VBA Thing, Anyway? |
|
|
11 | (10) |
|
Chapter 3: Where Does All That VBA Code Live? |
|
|
21 | (26) |
| Part II: Discovering the VBA Building Blocks |
|
47 | (96) |
|
Chapter 4: It Slices, It Dices, It's an Object! |
|
|
49 | (12) |
|
Chapter 5: Your Friend the Object Browser |
|
|
61 | (10) |
|
Chapter 6: Dot. Bang! You're Dead -- Bizarre Syntax Explained |
|
|
71 | (12) |
|
Chapter 7: Analyzing Excel Objects |
|
|
83 | (16) |
|
Chapter 8: A Word About Word Objects |
|
|
99 | (12) |
|
Chapter 9: Presenting Power Point Objects |
|
|
111 | (16) |
|
Chapter 10: Accessing Access Objects |
|
|
127 | (16) |
| Part III: Everything Else You Need to Understand about VBA |
|
143 | (26) |
|
Chapter 11: A Variable's Life |
|
|
145 | (14) |
|
Chapter 12: Conditioning Your Code |
|
|
159 | (14) |
|
|
|
173 | (18) |
|
Chapter 14: Subs and Functions and Arguments, Oh My! |
|
|
191 | (22) |
|
Chapter 15: Using VBA Built-in Functions |
|
|
213 | (16) |
|
Chapter 16: Creating User Forms |
|
|
229 | (22) |
|
Chapter 17: Planning for Trouble and Knowing How to Handle It |
|
|
251 | (18) |
| Part IV: Doing Cool Stuff with VBA and Office |
|
269 | (96) |
|
Chapter 18: Programming Excel Pivot Tables |
|
|
271 | (18) |
|
Chapter 19: Charting Excel Data |
|
|
289 | (14) |
|
Chapter 20: Hard-Core Find and Replace in Word |
|
|
303 | (14) |
|
Chapter 21: Making Mail Merge Work for You |
|
|
317 | (12) |
|
Chapter 22: Making PowerPoint Presentations Come Alive |
|
|
329 | (18) |
|
Chapter 23: Automating Access Reports |
|
|
347 | (18) |
| Part V: The Part of Tens |
|
365 | (32) |
|
Chapter 24: Ten Tips for Migrating Your Applications to Office 97 |
|
|
367 | (8) |
|
Chapter 25: Ten Sources of Cool and/or Free Stuff for Office 97 and VBA |
|
|
375 | (6) |
|
Appendix: About the Office 97 Developer Edition |
|
|
381 | (16) |
| Index |
|
397 | (13) |
| End-User License Agreement |
|
410 | (2) |
| Installation Instructions |
|
412 | |
| IDG Books Worldwide Registration Card (Back of Book) |
|
0 | |