Home  Switchboard  Unix Administration  Red Hat  TCP/IP Networks  Neoliberalism  Toxic Managers  
May the source be with you, but remember the KISS principle ;) Skepticism and critical thinking is not panacea, but can help to understand the world better 
News  Reviews  Definitive Guide to Excel VBA  Excel 2003 Power Programming with VBA  Excel Programming  Writing Excel Macros with VBA, 2nd Edition 
See also  Financial modelling  Random Findings  Humor  Etc 

Excel is a very powerful (and much underestimated) analytical tool that is as capable (or sometimes more capable) then many more expensive packages. People view Excel as a spreadsheet program for mass users. It fills this role quite well but in its capabilities is not a regular consumer program, it is a powerful professional analytical tool disguised as a commodity spreadsheet.

There are very few good books about Excel programming (and generally advanced Excel usage). I really hate John Walkenbach books, the author who actually almost monopolised the field.
Among few good books that are encounter I like Excel 2007 VBA Macro Programming by Richard Shepherd.
I once mistakenly bought weak and disorganized Excel 2003 Formulas Books John Walkenbach. Excel 2003 Power as well as Programming with VBA by the same author. After that I really hate John Walkenbach books, the author who actually almost monopolized the field :).
Of course much depends on what are do actually doing with Excel. My experience is limited to simple financial modeling (although it does used complex recurrent formulas).
Very weak and expensive cookbook, November 4, 2006
This is an eclectic collection of various recipies for Excel. This is a strange "lemmings" effect that the book has such a high rating on Amazon.
Reviewer: Nikolai N Bezroukov "kievite" (Budd Lake, NJ)  See all my reviews The book is essentially a badly written cookbook as it does not provide underling mechanics and key ideas behind the Excel formulas. Chapters are more or less disconnected and most of them can be read in any order.
At the end the reader is left with very new good findings that probably are not worth the price of the book.
Pagecount is very deceptive  considerable part of the book is fluff  brainless reproduction of basic things that one can find in help and that is not worth even one dollar. Many examples are very trivial and not worth reading.
Tricks like Appendix B are simply disgusting  the author just copied the listing of functions that has no practical value whatsoever to inflate the pagecount.
Explanations mostly are extremely fuzzy. The author has real talent to make simple things complex and complex things impossible. Also this is just "do like I said" type of cookbook: the author never tries to explain concepts that are used (use of absolute adressing vs relative, the syntax intricacies of the second argument of countif and similar functions, etc)
Also the book suffers from frequent references to previous versions of Excel, which only distract the reader. One can assume that if the reader really wants to use one of the previous versions of Excel he can buy prev. edition of the book and save money.
In few places were things became more interesting they are also incomplete and/or incorrect (creation of your own VBA functions and collection of functions, usage of array functions like frequency, etc).
My impression is the author is just a book writer and does not have rich real world experience with Excel, the experience that is necessary to distinguish between important and trivial things.
As a result he cannot provide the reader any help in getting the grasp of underling architectural ideas, that are often very nontrivial (Excel is extremely powerful analytical tool disguised as a commodity spreadsheet).
Jan 05, 2019  www.excelforum.com
 Re: Use a formula to determine which cells to format?
After select the cell (e.g. B1)enter formula: =A1>B1 and choose RED
then add new rule with formula =A1<B1 and choose GREEN from Fill tab.
If you are apply to group of cell horizontalwise, make sure the formulas don't contain $ signs that would make the references absolute.
Jan 03, 2019  stackoverflow.com
Using Lua for working with excel Ask Question 2
Animesh ,Oct 14, 2009 at 12:04
I am planning to learn Lua for my desktop scripting needs. I want to know if there is any documentation available and also if there are all the things needed in the Standard Lib.uroc ,Oct 14, 2009 at 12:09
You should check out Lua for Windows  a 'batteries included environment' for the Lua scripting language on Windowshttp://luaforwindows.luaforge.net/
It includes the LuaCOM library, from which you can access the Excel COM object.
Try looking at the LuaCOM documentation, there are some Excel examples in that:
http://www.tecgraf.pucrio.br/~rcerq/luacom/pub/1.3/luacomhtmldoc/
I've only ever used this for very simplistic things. Here is a sample to get you started:
 test.lua require('luacom') excel = luacom.CreateObject("Excel.Application") excel.Visible = true wb = excel.Workbooks:Add() ws = wb.Worksheets(1) for i=1, 20 do ws.Cells(i,1).Value2 = i endAnimesh ,Oct 14, 2009 at 12:26
Thanks uroc for your quick response. If possible, please let me know of any beginner tutorial or atleast some sample code for using COM programming via Lua. :) – Animesh Oct 14 '09 at 12:26sagasw ,Oct 16, 2009 at 1:02
More complex code example for lua working with excel:require "luacom" excel = luacom.CreateObject("Excel.Application") local book = excel.Workbooks:Add() local sheet = book.Worksheets(1) excel.Visible = true for row=1, 30 do for col=1, 30 do sheet.Cells(row, col).Value2 = math.floor(math.random() * 100) end end local range = sheet:Range("A1") for row=1, 30 do for col=1, 30 do local v = sheet.Cells(row, col).Value2 if v > 50 then local cell = range:Offset(row1, col1) cell:Select() excel.Selection.Interior.Color = 65535 end end end excel.DisplayAlerts = false excel:Quit() excel = nilAnother example, could add a graph chart.
require "luacom" excel = luacom.CreateObject("Excel.Application") local book = excel.Workbooks:Add() local sheet = book.Worksheets(1) excel.Visible = true for row=1, 30 do sheet.Cells(row, 1).Value2 = math.floor(math.random() * 100) end local chart = excel.Charts:Add() chart.ChartType = 4  xlLine local range = sheet:Range("A1:A30") chart:SetSourceData(range)Incredulous Monk ,Oct 19, 2009 at 4:17
A quick suggestion: fragments of code will look better if you format them as code (use the little "101 010" button). – Incredulous Monk Oct 19 '09 at 4:17
by Conrad Carlberg
Microsoft Press
February 25, 2004 NonTraditional Uses of Excell, May 24, 2005
Overall, I like this book, even though it is somewhat confusing, both in scope and in the target audience.
Reviewer: Lena (Toronto, Canada)  See all my reviews
The techniques of "naming the range" or writing the "if" formula are certainly targeted for beginners, but most of statistical tools are normally used by more advanced users.The worst thing, though, is that the book is full of errors, both typos and mistakes in problem solutions on the disk. I consider myself an intermediate user, so finding an error in "instructor solution" was more like an additional challenge for me, but for the beginner this could be very frustrating.
On the positive side  I really liked the idea of problems in the end of each chapter; so many books just give you the theory and then you do not know how to solve a real life problem. For most of chapters, I knew the tools, but still had to spend time figuring out the best way to implement it for problem solving.
Very practical book, good for an intermediate users. Just be aware of the typos !
This book is aimed at a level slightly higher than the total beginner. On page one, for instance he assumes that you understand the statement SUM(A5000:A5049) means. Then he points out that writing SUM(USSales) would make it easier to understand. He then describes how to name a range of cells  Not exactly what I'd call advanced, but certainly above novice.
Reviewer: John Matlock "Gunny" (Winnemucca, NV)  See all my reviews
The first third, or so, of the book is on these kinds of slightly advanced procedures that you could get out of several Excell books. After that he kind of turns the approach around to things like "Estimating a Demand Curve." This is looking for what you want to do rather than just looking at a technique within Excell.
Many of his chapters have fairly sophisticated subjects, "Incorporating Qualitative Factors into Multiple Regression." In this chapter he then looks at multiple factors that might go into predicting things like predicting sales, predicting the Presidential race  with fairly surprising results.
In a couple of chapters he has a bit of fun, i.e. Chapter 73 is "Picking Your Fantasy Football Team."
Excell is quite a powerful package. It can be used for a lot of things beyond just filling out an expense account. In this book a lot of non traditional uses are described in a very light but informative manner. It is a very well done book. Very practical, but full of errors, April 2, 2007
A remarkable book on creating complete Excelbased apps, April 13, 2005
 Paperback: 936 pages
 Publisher: AddisonWesley Professional; Bk&CDRom edition (February 1, 2005)
 Language: English
 ISBN: 0321262506
 Product Dimensions: 9.2 x 6.8 x 1.7 inches
Best Excel development book to date, April 26, 2006
The depth of Excel development knowledge of the authors can be readily seen a few pages into the Introduction. If you have been frequent visitors to Excel/VBA programming newsgroups like myself, you will notice immediately that all three authors are wellrecognized experts in this domain, and have answered countless tricky questions on the topic of Excel/VBA. In my opinion, the particularly valuable chapters include:
Reviewer: swsyuen "swsyuen" (Toronto, Ontario Canada)  See all my reviews  Chapter 3 on "Best Practices"
 Chapter 17 on "Optimizing VBA Performance"
 Chapter 19 on "XLLs/C API"
 Chapters 2021 on VB6
 Chapter 22 on VB.NET/VSTOThis is such a comprehensive book that will transform your Excel development skills to the professional level. Without reservation, the authors have delivered what the book title promises.
Reviewer: Raymond Lodato "grey geek" (Boston, MA)  See all my reviews
Over the years, I've read a number of books on Excel programming. Each one seemed much like the previous one, generally talking about writing macros and creating dataentry forms. Professional Excel Development takes the concept quite a bit farther. Rather than giving you the same old tired lessons, this book goes into detail on exactly how to build professional level applications. It even explains how to make your Excelbased application look as though Excel had nothing to do with it. Suffice it to say, this ain't your daddy's Excel book.
The authors, Stephen Bullen, Rob Bovey, and John Green, show a level of sophistication well beyond the norm. They'd rather teach you the proper way to program instead of teaching you how to use Excel. In fact, the first thing they do is distinguish five different levels of usage: Excel users, Excel power users, VBA developers, Excel developers, and professional Excel developers. The book is written for the highest level, so expect a lot of depth. The entire structure of the book builds around a timeentry application that is developed from a simple spreadsheet to a fullblown, production quality program. A CDROM is also included with all of the source code and multiple examples that are scattered throughout the book.
Reading Professional Excel Development is not something to be taken lightly. The authors have done a fine job putting together a cohesive methodology for using Excel as an application development platform. I know of no other book that covers this platform in such depth. At times I found myself lost in the details, but I suspect a "professional Excel developer" (which I am not) would be delighted in the depth of description and copious examples provided.
Professional Excel Development is an extremely wellwritten book that covers the use of Excel to a depth few authors have dared to tread. The text gives you the tools to build applications that are much more than automated spreadsheets. Almost any program your imagination can devise can be created using the techniques given, which is a testimony to the power of Excel.
Bash Microsoft if you want, but they do sometimes come up with a winner, and Professional Excel Development allows you to take full advantage of its capabilities. I highly recommend this book...
Reviewer: Ruslan Moskalenko "Ruslan Moskalenko" (Pleasanton, CA United States)  See all my reviews
It's a great book! It actually consists of two parts: a brief but very useful VBA overview with all popular tricks and hints in the beginning and a deep and complete reference at the end. Normally you need to buy two separate books to get this coverage. This book can get you started in a few hours and answer virtually all your questions going forward. Really, really good!If you are reading this review, buy this book now., December 2, 2003
If you are interested enough to read this review, then buy this book. Now. I have done quite a bit of programming ... The only problem was, I had never programmed VBA/Excel and was having a very rough time getting started.
Reviewer: Dennis Eichenlaub (Kingsville, MD United States)  See all my reviews I bought "Excel 2002 VBA Programmer's Reference". I sat down and started reading Chapter 2. Before long, I was so excited that I was firing up my laptop. Four hours after I started reading the book, I had a prototype up and running. This book is amazing. Chapter 2 gave me more useful information than I sometimes get from an entire book. ...
The authors are simply bursting with knowledge and give it freely. Ideas are expressed clearly and succinctly. Knowledge is wellorganized and easy to find. Whether you want to approach the topic methodically or flip through looking for gems, you will find what you want here.
Getting the object model is a great bonus. I'm going to enjoy spending a few days going through this one.
John Matlock "Gunny NonTraditional Uses of Excell, May 24, 2005
This book is aimed at a level slightly higher than the total beginner. On page one, for instance he assumes that you understand the statement SUM(A5000:A5049) means. Then he points out that writing SUM(USSales) would make it easier to understand. He then describes how to name a range of cells  Not exactly what I'd call advanced, but certainly above novice.
The first third, or so, of the book is on these kinds of slightly advanced procedures that you could get out of several Excell books. After that he kind of turns the approach around to things like "Estimating a Demand Curve." This is looking for what you want to do rather than just looking at a technique within Excell.
Many of his chapters have fairly sophisticated subjects, "Incorporating Qualitative Factors into Multiple Regression." In this chapter he then looks at multiple factors that might go into predicting things like predicting sales, predicting the Presidential race  with fairly surprising results.
In a couple of chapters he has a bit of fun, i.e. Chapter 73 is "Picking Your Fantasy Football Team."
Excell is quite a powerful package. It can be used for a lot of things beyond just filling out an expense account. In this book a lot of non traditional uses are described in a very light but informative manner. It is a very well done book.
Patrick B. Meegan Worthwhile in spite of shortcomings, May 26, 2006
I readily admit that the mistakes in the CD are an impediment to learning, but I think the book still has value for users who are looking for the application to business. Many of the CD's chapters were fine and proved very useful and I don't agree with other reviewers that the CD is flawed beyond use. Users of this book can glean a great deal from the unflawed majority of the book.D. Lamont "cloud" CD has MANY, MANY mistakes...., August 25, 2004
The idea behind this book is great.The book introduces and expands on many different 'useful' formulas and tools included within Excel.
The problems at the end of each chapter allows the reader to use what was just learned in developing spreadsheets to solve realistic accounting problems.Even the 'above average' user of Excel, I believe, will learn from this book.
The CD even has an electronic version of the book, so you don't have to carry the book around everywhere.
The main problem: the CD STINKS !!!! It has MANY, MANY errors.
From forgetting to take into account given growth rates detailed in a problem (therefore yielding incorrect answers) to just plain sloppy copying of sheets (forgetting to delete the drawings and numbers not pertinent to the current sheet).
As said in a prior review, if an updated CD were to become available, with the CORRECT ANSWERS on it, this would be a definite 5 star.
(This said, perhaps finding the errors on the CD could be a means of developing your spreadsheets skills):)"wallstbully11729" Great Book!! Very Useful, March 23, 2004
I love this book. This Book is a must for anyone who wants to learn how to use Excel to perform Data Analysis and Business modeling. I learned alot from this book. Winston shows us how to use Excel functions and shows us with examples. Plenty of examples and answers provided with the CD. This is a very good "foundational" book. You should also check out the book by Jackson and Staunton "Advanced modeling in finance using Excel and VBA". A book by Sengupta "Financial Modeling using Excel and VBA" is also worth looking at. I own all 3 books
Edition: Hardcover 35 used & new from $19.45 7 of 7 people found the following review helpful:
Master Modeling employing Excel, September 23, 2005
This book focuses on several management science modeling problems and explains clearly how to implement them with Excel.Winston teaches you how to employ standards (colors, borders, etc) to make your spreadsheet more professional. You will learn much about Excel even if you are not interested in management science models.
Contrary to Optimization and Operations Research books, it does not worry about algorithm details, being directed mainly to develop the student modeling skills.
And as a friend told me "I guess anything by this author is worth the money"
Then, if your goal is to find a text that contains excelbased ways of solving managerial problems, and you are not concerned with solver details (simplex method, transport algorithms, nonlinear programming algorithms, interior point methods) this book is for you.
Another information: Chris Albright has a Modeling book directed to people that want to learn how to use VBA in modeling, that is, if you are a "want to be advanced" Excel user. He says that his VBA book is the natural next step to "Practical Management Science".
by John Walkenbach (Paperback  Jan 13, 2004)
An average book. For beginners only.
Great showcase of Excel's mathematical capabilities, February 6, 2006
It is often either inconvenient or financially unfeasible to solve every mathematical problem with a standalone procedural language or an expensive application such as Matlab or Mathematica.
Reviewer: calvinnme "Texan refugee" (Fredericksburg, Va)  See all my reviews Since Excel has such advanced computational capabilities built into it and is ubiquitous in offices and homes, it would make sense to mine this application for numerical problem solving techniques.
Bourg does a masterful job of presenting the tools available in Excel and showing the reader how to put them to work to solve real world engineering and mathematical problems.
First, he spends a couple of chapters briefly going over Excel and its language VBA (Visual Basic for Applications). Next he goes over some intermediate level tasks such as collecting and cleaning up data, charting including 3D charts, and statistical analysis tasks such as correlating data and generating random numbers.
Next Bourg moves into purely mathematical tasks such as working with discrete Fourier transforms, manipulating matrices and vectors, as well as working with basic mathematical functions.
Once you have learned to use these mathematical tools in Excel, Bourg uses them to show you how to perform curve fitting and regression, solve equations, perform integration and differentiation, and solve both ordinary and partial differential equations. He even spends time on performing multivariable calculus and the finite element method in Excel. Chapter 13, on optimization, was my favorite chapter.
Here, Bourg is actually getting into a little algorithm analysis and design via linear programming and genetic algorithms. This chapter showed me some truly innovative uses of Excel. The final chapter deviates from the scientific flavor of the book and concentrates on more traditional financial applications.
The writing is very accessible, the examples are clear and very creative, and the author does a tremendous job of capturing the range of Excel's mathematical capabilities. Do not expect mathematical theory in this book. Bourg assumes you already know how to set up a mathematical problem and that you just need a computational platform and tools with which to perform your work. It is nice to know I am not necessarily held hostage by Mathworks(maker of Matlab) every time I need to solve a mathematical problem of any level of sophistication. Highly recommended.
The table of contents is as follows:
1. Using Excel
2. Getting Acquainted with Visual Basic for Applications
3. Collecting and Cleaning Up Data
4. Charting
5. Statistical Analysis
6. Time Series Analysis
7. Mathematical Functions
8. Curve Fitting and Regression
9. Solving Equations
10. Numerical Integration and Differentiation
11. Solving Ordinary Differential Equations
12. Solving Partial Differential Equations
13. Performing Optimization Analyses in Excel
14. Introduction to Financial Calculations
 Paperback: 262 pages
 Publisher: O'Reilly Media, Inc.; 1 edition (January 3, 2006)
 Language: English
 ISBN: 0596100736
 Product Dimensions: 9.1 x 6.7 x 0.7 inches
 Shipping Weight: 14.7 ounces. (View shipping rates and policies)
 Average Customer Review: based on 1 review.
Definitive Guide to Excel VBA, Second Edition
by Michael Kofler, David Kramer (Translator)
One of the definitive guides to Excel VBA books, August 21, 2002
Reviewer: Weiqin Xie (see more about me) from Plainsboro, NJ United StatesI won't say this book is "the only Excel VBA book you will need"  there is no such kind of thing for programming books. However, I like to say it is one of the best and definitive guides to Excel VBA.
The most important thing is that there are several advanced topics you won't find on the other popular Excel VBA books (such as Excel 2002 VBA programminer's Reference by Stephen Bullen, John Green et al. or Excel 2002 Power Programming with VBA by John Walkenback): for instance, recursion, details of random numbers generation, matrix functions, automatic data reporting, OLAP functionality and using Excel as ActiveX server.
However, I also must say this book is definitely not for the beginners to learn VBA. This text refers to an out of print or unavailable edition of this title
Good organization, a bit terse, January 4, 2001
Probably the two books to compare with are Walkenbach's "EXCEL 2000 Power Programming", and Green's "EXCEL 2000 VBA". A related book that is a description of the language with nothing about the EXCEL object model is Lomax "VB & VBA in a Nutshell".
Reviewer: John Robert Brews from Santa Fe, NM Kofler can be cryptic at times. As explanation, he says (p. 336) "The long and the short of it is that you [dear reader] will not be spared the opportunity to do a bit of experimenting yourself". An example of this brevity is the treatment of the MsgBox, which is used to interrogate the user of the spreadsheet and offer a variety of choices. Kofler provides an example on p. 220, and refers the reader to the online help for amplification. In contrast, Julitta Korol offers over 7 pages of examples and tables using this function. The pro of brevity is many features can be outlined, and the reader can find the additional info for free. The con is that the reader won't appreciate the full utility of the feature without perusing the online help in some detail.
Compared to Walkenbach, Kofler has more about features new to EXCEL 2000. For instance, Kofler has subroutines illustrating the use of the Implements statement in VBA, while Walkenbach lists it as a statement with no comment, Green doesn't even mention it. Lomax has a complete discussion pp. 373  375. Kofler also describes the manipulation of files using the FSO (File System Objects) Library (pp. 245ff.), a new feature.
Compared to Green, Kofler is almost entirely exposition, while pp. 343695 of Green is a listing of the EXCEL 2000 and VBE object models, which I personally find not too useful. However, because the first 245 pages of Green is compact, I find it easier to find information there.
Kofler definitely is a notch more advanced than Walkenbach, at least as knowledgeable, and much better organized. In fact, although there is a lot of overlap, it is handy to have both books because it is usually possible to find what you want in Kofler, and then (sometimes) use Walkenbach for a more detailed handholding example. However, finding something in Walkenbach by itself requires luck because of his poor organization and index.
None of the three EXCEL books describes the special status of sub main().
Bottom line: Buy Green first (cheapest), Kofler second and Walkenbach last. This text refers to an out of print or unavailable edition of this title
Great reference book!, August 21, 2003
This book has proved a life saver on more than one occasion. It is written in easy to understand language and organized in a way that doesn't force you to read the entire chapter to glean the one tidbit of information you were searching for. If you are looking for a tutorial style book, this isn't it, however if you are looking for a book that gives you answers quick  you're in luck. It has a thorough, helpful index. My one gripe is that I have found that the examples are a little scarce. I would like to see more examples of actual code. All in all, I am very pleased with my decision to purchase this book. This text refers to an out of print or unavailable edition of this title
Reviewer: A reader from Kansas City, MO This book was my bible, June 12, 2003
This book was my bible for VBA & Excel while creating an application for work. I thought about getting Walkenbach's "EXCEL 2000 Power Programming", but my dad owned that one so I figured I could always borrow it if needed  but I never did need it.
Reviewer: Michael R Mayer (see more about me) from Fort Worth, TX United States I had not written a single line of Visual Basic or VBA prior to getting this book  I learned everything I needed here. (Although I had plenty of experience in C++/Java).
A few comments  I liked his style of mostly providing textual descriptions of all the different Excel classes, methods, and properties. There's not a lot of code in the book  but I never missed it. He provided clear enough descriptions of how to use the Excel object model, that I didn't need a ton of printed code to reinforce (don't get me wrong, there IS code within the book + the sample CD, just not pages and pages reflecting an entire application he's building up, like you get in a cookbook). If you prefer to just cut&paste code from a book into your own app, then you might be better off with Walkenbach's book.
The book was originally written in German and then translated to English, but I only remember one or two times where that became evident.
I wholeheartedly recommend this book.
by John Walkenbach (Author); Paperback
Good for beginners and intermediate alike, June 13, 2003
As someone who has some programming experience, this book was very helpful to me.
Reviewer: dansa28 (see more about me) from Dansa28, Whangarei, New Zealand
The project I am working on was already defined, and all I had to do was look in the books where an example was given or a syntax reference existed. Note that I used it in alongside O'Reilly Press' 'Writing Excel Macros with VBA'. Where certain areas aren't covered in this book (rare), there will almost certainly be something in the other.As an intermediate level parttime but somewhat rusty programmer (mostly selftaught) of Java, C, Javascript, HTML, CSS, XML, Assembly and others, this book certainly had what I was looking for.
It offers useful language references and the descriptions are ample, although occasionally apparently useful methods that were covered in 'the other' book and were overlooked in this one; it's just not possible to include everything though, even in ~1000 pages.
It assumes some prior knowledge of programming techniques, and is therefore not for the absolute beginner, but will serve it's purpose very well indeed to the majority.
I would recommend this book all except the absolute beginner and the advanced programmer/expert (who probably wouldn't be reading this anyway!). Definitely worth the money.
I rarely buy books on the internet without having a good flick through them at the local bookshop first. In this case I would advise likeminded thinkers to make an exception.
The included CDROM is worth it's weight in gold and is all too often a crucial ommission by authours/publishers. I can now take the book with me on my laptop in PDF format (hooray!) and all of the book examples are included too. BONUS!
Very light in content. Cannot do much after reading it, July 25, 2003
First of all, I am nonEnglish speaker (forgive my English). I am an Electrical Engineer, not a programmer. But I have many years programming experiences in different languages (on my own!).
Reviewer: book_addict1 (see more about me) from SOMEWHERE I have finished up to chapter 10. The contents is very light. It talks about very basic syntax that are almost the same in any language (e.g. C, Java, Perl C++...) It puts hundreds of pages that can be done in a half of the volume. It does not tell you much about the object details. It seems to tell you to explore the objects and methods by recording macro and learning by trial and error. If so, I don't need this book.
First of all, time is money. I spent money, time to read hundreds of pages. The author suggests you to trial and error. I really don't think it is a very good book. But I still give 3 stars (I am quite generous!)
Maybe most audiences of this book are never program in his/her life. This may be good for them. For someone who has experiences in programming. It is not very useful.
The author should really concentrate on objects and methods after some basic syntax. That is the most important. I can learn the syntax in few days. But I don't know much about all the objects and methods. Without knowing the objects and methods, nobody can do much. Just like learning English, you know all the syntax but you don't know any WORDS and USAGE. What do you think you can write!
The Title of the Book has Been Mistaken, December 4, 2003
Reviewer: J. Polihronov from London, UKWhen I bought the book, I was impressed by its title and TOC since they give the promise of leading the reader into macro programming. However, it is rather a largevolume Excel/VBA reference, not a book on how to write macros.
Unfortunately, there is no system of introducing the reader gradually into the language (as in all usual programming textbooks) by introducing concepts, giving examples and requesting particular exercises.On a positive note, the book contains (all) VBA concepts relevant to Excel macros and can very well serve as a future reference once the reader has bought another book to learn how to code within some range of macro programming.
VERY USEFUL COMPANION, June 13, 2003
Reviewer: A reader from Dansa28, Whangarei, New ZealandAs someone who has some programming experience, this book was very helpful to me.
The project I am working on was already defined, and all I had to do was look in the books where an example was given or a syntax reference existed. Note that I used it in alongside Walkenbach's Excel 2002 Power Programming with VBA. Where certain areas aren't covered in this book (as it's only 500 pages), there will almost certainly be something in the other.
As an intermediate level parttime programmer (mostly selftaught) of Java, C, Javascript, HTML, CSS, XML, Assembly and others, this book certainly had what I was looking for.
It mainly offers concise language references and the descriptions are kept to the necessary, and this O'Reilly book is a vast improvement on some that I have bought for other languages in the past.
It does however assume some prior knowledge of programming techniques, and is therefore not for the beginner.
I would recommend THIS book only to those who have either a very keen interest in programming or those who have had some formal programming teaching. Definitely worth the money though.
By: Michael Alexander
Publisher: John Wiley & Sons
Pub. Date: March 04, 2008
The Last but not Least Technology is dominated by two types of people: those who understand what they do not manage and those who manage what they do not understand ~Archibald Putt. Ph.D
Copyright © 19962018 by Dr. Nikolai Bezroukov. www.softpanorama.org was initially created as a service to the (now defunct) UN Sustainable Development Networking Programme (SDNP) in the author free time and without any remuneration. This document is an industrial compilation designed and created exclusively for educational use and is distributed under the Softpanorama Content License. Original materials copyright belong to respective owners. Quotes are made for educational purposes only in compliance with the fair use doctrine.
FAIR USE NOTICE This site contains copyrighted material the use of which has not always been specifically authorized by the copyright owner. We are making such material available to advance understanding of computer science, IT technology, economic, scientific, and social issues. We believe this constitutes a 'fair use' of any such copyrighted material as provided by section 107 of the US Copyright Law according to which such material can be distributed without profit exclusively for research and educational purposes.
This is a Spartan WHYFF (We Help You For Free) site written by people for whom English is not a native language. Grammar and spelling errors should be expected. The site contain some broken links as it develops like a living tree...
You can use PayPal to make a contribution, supporting development of this site and speed up access. In case softpanorama.org is down you can use the at softpanorama.info 
Disclaimer:
The statements, views and opinions presented on this web page are those of the author (or referenced source) and are not endorsed by, nor do they necessarily reflect, the opinions of the author present and former employers, SDNP or any other organization the author may be associated with. We do not warrant the correctness of the information provided or its fitness for any purpose.
The site uses AdSense so you need to be aware of Google privacy policy. You you do not want to be tracked by Google please disable Javascript for this site. This site is perfectly usable without Javascript.
Last modified: February 11, 2019