Average Reviews:
(More customer reviews)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.
Click Here to see more reviews about: VBA Developer's Handbook, 2nd Edition
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.
Click here for more information about VBA Developer's Handbook, 2nd Edition
0 comments:
Post a Comment