VBA Developer's Handbook (eBook)

Ken Getz, Mike Gilbert (Autoren)

eBook Download: PDF

2006 | 2. Auflage
1104 Seiten
Wiley (Verlag)
9780782153330 (ISBN)

Infos

WRITE BULLETPROOF VBA CODE FOR ANY SITUATION This book is the essential resource for developers working with any of the more than 300 products that employ the Visual Basic for Applications programming language. Written by recognized VBA experts, it provides detailed coverage of a wide range of specific VBA programming challenges. Its careful, step-by-step instructions and thousands of lines of code offer answers, while teaching you to devise new and creative solutions. The instruction applies equally to all VBA environments, whether you are building standalone applications or customizing commercial products using their built-in VBA programmability. Coverage Includes Manipulating text, numbers, and dates Using automation to control other applications Creating objects using VBA class modules Using standard search and sort algorithms from within VBA Creating standard dynamic data structures, including linked lists, binary trees, stacks, and queues Working with Windows system information, including memory status, screen info, mouse, keyboard, and power status Working with Windows Registry data Retrieving and setting Windows networking information Working with the Windows file system, iterating through folders, creating and deleting files Adding sound and movies to VBA apps using Windows multimedia extensions Tapping the system capabilities provided by the Windows Scripting Runtime library Writing add-ins for the Visual Basic environment Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Autor

Getz is Senior Consultant with MCW Technologies, a frequent speakerat developer conferences throughout the world, and contributingeditor for Office & VBA Developer and Access-Office-VBA Advisormagazines. He is the coauthor of the best-selling AccessDeveloper's Handbook. Gilbert is Product Manager with Microsoft'sDeveloper Tools division, specializing in VBA. He is a columnistfor Office & VBA Developer magazine and a regular speaker atMicrosoft TechEd and other developer conferences.

Inhalt

Introduction xxi

Chapter 1: Manipulating Strings 1

Chapter 2: Working with Numbers 93

Chapter 3: Working with Dates and Times 143

Chapter 4: Using VBA to Automate Other Applications 223

Chapter 5: Creating Your Own Objects with VB Class Modules 271

Chapter 6: Advanced Class Module Techniques 305

Chapter 7: Searching and Sorting in VBA 369

Chapter 8: Creating Dynamic Data Structures Using Class Modules 431

Chapter 9: Retrieving and Setting System Information 485

Chapter 10: Managing Windows Registry Data 597

Chapter 11: The Windows Networking API 633

Chapter 12: Working with Disks and Files 701

Chapter 13: Adding Multimedia to Your Applications 809

Chapter 14: Using the Scripting Runtime Library Objects 879

Chapter 15: Writing Add-Ins for the Visual Basic IDE 931

Appendix A: The Reddick VBA Naming Conventions, Version 6 999

Index 1025

Produkt-Details

• Erscheint lt. Verlag: 26.7.2006
• Sprache: englisch
• Themenwelt: Mathematik / Informatik ► Informatik ► Programmiersprachen / -werkzeuge
• Schlagworte: Computer Science • Informatik • Programmierung / Visual Basic • Programming / Visual Basic • VisualBasic für Applikationen • VisualBASIC für Applikationen
• ISBN-13: 9780782153330 / 9780782153330