VBA Developer's Handbook, 2nd Edition | 
| Authors: Ken Getz, Mike Gilbert
Publisher: Sybex
Category: Book
List Price: $49.99
Buy New: $19.99
You Save: $30.00 (60%)
New (28) Used (21) from $17.95
Avg. Customer Rating:  26 reviews
Sales Rank: 215263
Media: Paperback
Edition: 2
Number Of Items: 1
Pages: 1104
Shipping Weight (lbs): 4.2
Dimensions (in): 8.9 x 7.6 x 2.3
ISBN: 0782129781
Dewey Decimal Number: 005
UPC: 025211229781
EAN: 9780782129786
Publication Date: April 25, 2001
Availability: Usually ships in 1-2 business days
|
| Also Available In:
|
| Similar Items:
|
| Editorial Reviews:
Product 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
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
|
| Customer Reviews: Read 21 more reviews...
 I'm not a programmer ... October 19, 2007
2 out of 2 found this review helpful
but I wanted to calculate an average cost per day. Obviously the number of days in a month depends on the month.
No problem. Pop in the CD included ... copy ... paste into your VBA Module ...
Locate your spreadsheet's cell ... type "=dhDaysInMonth(Month)" ... done.
If you've written any macros at all or even recorded one ... you will appreciate the amount of work you're buying for a little over thirty bones.
Highly recommended. As page 196 says, 'You'll get better performance (and fewer bugs) by taking advantage of the work that's already been done.'
This book is a bargain.
Mange Takk!
Excellent! Great book July 17, 2007
2 out of 2 found this review helpful
This is really the best book i ever found. I have bought several books for Excel VBA. Non of them will explain as detail as this book. Besides, for those people who really interest in VBA, this is really a good book where you can start solve more complex problem.
Non of the books so far i found will teach you how to create data structure using VBA e.g binary tree, linked list, queue and stack thru VBA implementation. it is worth while to keep this book for your future reference...
 Excellent reference book for Intermediate users July 13, 2007
3 out of 3 found this review helpful
In the introduction the authors state : "To make it possible to stuff as much code into this book, we've had to dispense with material specifically geared for beginners"
I like that - a lot of 'reference' books I've purchased waste many chapters devoted to topics that I would expect to find in 'Inroduction' or 'Beginners' - titled books.
This tome however (all 1073 pages of it!) is totally dedicated to useful code snippets and sound programming principles.
Despite its size I find the book logically structured and very easy to locate the information I need, very quickly - the "Contents at a Glance" page helps immensly.
I'd definitely recommend this book for any VBA developer as an essential resource.
Thorough, Instructional, with great code samples February 27, 2006
9 out of 9 found this review helpful
This book has gotten me out of many scrapes. It is a rare book that can be read from the beginning, while trying out the sample code, as a way to learn the language, or as a reference book, to look up how to use a certain function effectively while writing code. Don't let the title fool you, this book is for those coding in VB just as much as it is for those using VBA. If you are going to buy one book on Visual Basic, let this be the one. If you are going to buy one book on Visual Basic, and see one movie this year, then buy this book and see Amelie. ;)
Reference Book November 30, 2003
6 out of 12 found this review helpful
Good reference book... help you find tricks to do automation and to maximize the output of your VBA code. Not for newbies.
|
|
|
|
