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.

Product Details

• Amazon Sales Rank: #301736 in Books
• Published on: 2001-04-25
• Original language: English
• Number of items: 1
• Binding: Paperback
• 1104 pages

Book Info
Provides detailed coverage of a wide range of specific VBA programming challenges. Covers string handling, searching and sorting, working with dates, understanding class modules and more. Paper. CD ROM included.

From the Back Cover
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

  About the Author
  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.

Customer Reviews

I'm not a programmer ...
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
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
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.