Part I Unleashing the VBA Programming Language
- 1 Introducing VBA 3
- 2 Understanding Variables 39
- 3 Building VBA Expressions 59
- 4 Working with Objects 93
- 5 Controlling Your VBA Code 115
Part II Unleashing Microsoft Office Objects
- 6 Word for Windows VBA Programming 139
- 7 Manipulating Excel with VBA 171
- 8 Programming PowerPoint Presentations 217
- 9 VBA and Access 247
Part III Unleashing VBA User Interface Design
- 10 Interacting with the User 277
- 11 Working with Microsoft Forms 295
- 12 Creating Custom Menus and Toolbars 333
Part IV Unleashing Application Integration
- 13 Working with Other Applications 359
- 14 Programming OLE and ActiveX Objects 381
- 15 Controlling Applications Via OLE Automation 409
- 16 Rolling Your Own Objects with Class Modules 423
Part V Unleashing VBA Database Programming
- 17 Using VBA to Work with Excel Lists 445
- 18 Programming Data Access Objects 469
- 19 Advanced Database Programming 493
Part VI Unleashing VBA Internet and Intranet Programming
- 20 Internet and Intranet Programming Topics 535
- 21 Web Page Programming: ActiveX and VBScript 567
- 22 E-Mail and Groupware Programming with Outlook 603
Part VII Unleashing Advanced VBA Programming
- 23 Trapping Program Errors 653
- 24 Debugging VBA Procedures 669
- 25 Programming the Windows API 689
- 26 VBA Tips and Techniques 727
Part VIII Unleashing VBA Applications
- 27 A Check Book Application 769
- 28 Making Backups as You Work 799
- 29 Access and Outlook: E-Mail Merge 833
A VBA Statements 865
B VBA Functions 873
C The Windows ANSI Character Set 883
D An HTML Primer 891
[此贴子已经被作者于2005-9-30 21:10:00编辑过]
|