Spreadsheet Sorcery: Making a living with Excel VBA

By Orrin White and Mr Orrin White

We, with the pretentiousness of a new wine, identify with the programmers described by one author as magicians - those who always seem to come up with new solutions and always meet their deadlines - hence Spreadsheet Sorcery. Spreadsheet Sorcery is a book of programs that, among other things, are excerpts of systems and complete systems ranging from manual reviews to fully automated expanding and contracting systems, including an entirely event driven system. Within are 303 "macros" - programs from one line to several pages in length; qualifying as routines, subroutines and functions. Spreadsheet Sorcery features logic, the high-level language being used is Visual Basic for Applications i.e. EXCEL VBA. It was tenacity on our part that engendered these programs and tenacity on your part that will result in revelation. These are all macros that work (they run) and that have helped us to do our work. In most cases, they are our work. Readers should use this book as a reference in writing their own custom routines by examining the content while occasionally referring to the accompanying comment, aligned conveniently for their reference on the opposing page. With this book you can make, and push, your own buttons. Millions of users have ignored VBA, this wonderful feature that has been available to all who have EXCEL installed on their system. Since over 40% of the households in the United States have at least one system at home, it seems that this unmined resource will not soon be exhausted. The logic and the techniques revealed in this book can be adapted to any imaginable spreadsheet utilization. Those of you who find yourselves using Excel in any capacity will benefit, measurably, from the techniques presented in Spreadsheet Sorcery.

• Format: Paperback
• Language: English
• ISBN: 1468134701
• ISBN13: 9781468134704
• Release Date: April 2012
• Publisher: CreateSpace Independent Publishing Platform
• Length: 408 Pages
• Weight: 1.41 lbs.
• Dimensions: 8.5" x 1.0" x 5.5"