VBA Developer's Handbook
2nd Edition
Published on 28. May 2001
Book
Paperback/Softback
1104 pages
978-0-7821-2978-6 (ISBN)
Description
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
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
More details
Edition
2., Auflage
Language
English
Place of publication
New York
United States
Publishing group
John Wiley & Sons Inc
Edition type
Revised edition
Illustrations
illustrations
Dimensions
Height: 22.7 cm
Width: 19.5 cm
Thickness: 57 mm
Weight
1916 gr
ISBN-13
978-0-7821-2978-6 (9780782129786)
Schweitzer Classification
Other editions
Previous edition
Ken Getz
VBA Developer's Handbook
Book
03/1997
Sybex Inc.,U.S.
€76.94
Article exhausted; check for reprint
Persons
Getz is Senior Consultant with MCW Technologies, a frequent speaker at developer conferences throughout the world, and contributing editor for Office & VBA Developer and Access-Office-VBA Advisor magazines. He is the coauthor of the best-selling Access Developer's Handbook. Gilbert is Product Manager with Microsoft's Developer Tools division, specializing in VBA. He is a columnist for Office & VBA Developer magazine and a regular speaker at Microsoft TechEd and other developer conferences.
Content
Introductionxxi Chapter1:Manipulating Strings.
Chapter2:Working with Numbers.
Chapter3:Working with Dates and Times.
Chapter4:Using VBA to Automate Other Applications.
Chapter5:Creating Your Own Objects with VB Class Modules.
Chapter6:Advanced Class Module Techniques.
Chapter7:Searching and Sorting in VBA.
Chapter8:Creating Dynamic Data Structures Using Class Modules.
Chapter9:Retrieving and Setting System Information.
Chapter10:Managing Windows Registry Data.
Chapter11:The Windows Networking API.
Chapter12:Working with Disks and File.
Chapter13:Adding Multimedia to Your Applications.
Chapter14:Using the Scripting Runtime Library Objects.
Chapter15:Writing Add-Ins for the Visual Basic IDE.
Appendix A:The Reddick VBA Naming Conventions, Version 6.
Index
Chapter2:Working with Numbers.
Chapter3:Working with Dates and Times.
Chapter4:Using VBA to Automate Other Applications.
Chapter5:Creating Your Own Objects with VB Class Modules.
Chapter6:Advanced Class Module Techniques.
Chapter7:Searching and Sorting in VBA.
Chapter8:Creating Dynamic Data Structures Using Class Modules.
Chapter9:Retrieving and Setting System Information.
Chapter10:Managing Windows Registry Data.
Chapter11:The Windows Networking API.
Chapter12:Working with Disks and File.
Chapter13:Adding Multimedia to Your Applications.
Chapter14:Using the Scripting Runtime Library Objects.
Chapter15:Writing Add-Ins for the Visual Basic IDE.
Appendix A:The Reddick VBA Naming Conventions, Version 6.
Index