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: #217350 in Books
• Published on: 2001-05-14
• Original language: English
• Number of items: 1
• Binding: Paperback
• 1104 pages

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

An excellent, worth every penny, book!
I have had this book for a long time and thought I should put in my .02 cents worth.

Please do not let some of the earlier reviews fool or confuse you. This is a VBA based book. What does that mean? First off it means that it covers the common programming language 'Visual Basic for Applications' (VBA) that is used by Microsoft Office as well as third party products like Visio, AutoCAD, etc. Second, 'the language' VBA is the same 'programming language' which is used by 'the product' Visual Basic 5.0/6.0 from Microsoft. Think of it this way: Microsoft Visual C++ is a Windows development tool that uses the language C++. Microsoft Excel is a spreadsheet tool that happens to contain a full blown programming language, VBA. In addition, Microsoft happens to sell a 'Windows development tool', called Visual Basic which in turn contains a full blow programming language, VBA. Except for some minor differences, the VBA in Office 97 is the 'same' as the version in the product Visual Basic 5.0.

This book does not pretend to be about 'the Visual Basic product' or any of the Microsoft Office products. It is about the 'common' programming language, VBA, which they (Visual Basic, Office, Visio, etc.) share! Some of the previous reviewers seem to be confused to these facts.

While the current edition of this book covers the version of VBA released with Office 97, all of the code would work in Visual Basic 5.0 or 6.0, Visio, AutoCAD, etc. In fact, with the release of VBA 6.0, the 'common programming language' will be the same in Visual Basic 6.0 and Office 2000 and soon to be released versions of Visio, etc.

This excellent book will NOT show you how to do database programming in Access, spreadsheet programming in Excel, or document programming in Word. It will NOT show you how to write ActiveX DLL's using the Visual Basic PRODUCT or do DCOM programming.

This book WILL however show you how to write great VBA code (remember, the language) you can use in any of the previously mentioned products. In addition, you will obtain code that will help you get system information, perform 'correct' date calculations, access the system registry, use multimedia features and more! Remember, if I'm wrong, you can send the book back. Nevertheless, if you want to get some understanding about the VBA 'language', get this book.

Cost
Why is this book (published 2001) a lot cheaper than the 1997 version. It contains the same, albeit, updated stuff. I agree with some of the other reveiws I have read - it's a disappointment in the way it deals with (or, rather, DOESN'T deal with) the interaction between itself and Excel and Word, which are the reasons we have VBA. Having said that, if you already know your way around Excel et al, and need a VBA book to enhance your already impressive skills, then this could be it. I liked it and will keep it by me for all future projects. Buy it, it's worth it

MSI Creation Reference
Simply put - "The Daddy" for use as an MSI packager's reference guide to creating , editing or troubleshooting MSI packages. Whenever I need to look something up beyond the Help files of my MSI authoring tool , or need to resolve an ORCA ICE error, this book is my first and usually last port of call.

It would have taken me an awful lot longer to get to grips with the MSI technology without this book. No hesitation in reccommending it to novice and expert MSI packagers alike.