Visual Basic Microsoft Windows Books : VBA and Macros for Microsoft Excel (Business Solutions)

VBA and Macros for Microsoft Excel (Business Solutions)

£13.99


Should include FREE magnifying glass ! - I ve just started this book, and so far it seems well-suited to my needs (as a complement to and hopefully a next step up from For Dummies) but there is one BIG problem :all screen prints in the book have acres of white space all around them and so are consequently only 8 cm wide !(to portray what would be 40cm wide on your screen). This is OK for some simple dialog boxes, but when it comes to the fullscreen dumps of the VBA Help etc, then this is just plain UNREADABLE). As a result you have to open up Excel and look at it onscreen. OK, so this is far from impossible most of the time, but it doesn t allow the book to be read on the train !PS. ...and it just got worse! I ve only reached page 55 (out of 500+) and one of the first examples of code given in the book is wrong (Row.Count instead of Rows.Count) so the code won t run in the given form.P.P.S but I m still ploughing through it and it IS rather good. Not only all the theory you need, but also lots of great examples that can easily be adapted to most people needs. (Can t seem to be able change the above rating to 4 stars.)

Could do better - This book spends too much time giving you cool examples to impress your clients and not enough time explaining the syntax of the language. Also, the book does assume a little more in the way of programming knowledge than it claims, e.g. use of DIM statement is never explained.All I wanted from a VBA manual was a dry, comprehensive syntax/semantics-oriented guide. What this book does is give small examples of what individual properties can do, then build these up into useful macros. The problem is that if you want to write some code slightly different to the example given in the book, it takes a lot of digging to find out how.

Hard Going - If you are a bit dim like me you are going to struggle with this book, but persistance pays off. It does eventually sink in.

An excellent buy. Far more useful than those 500+ page everything about... tomes - This is one of those rare things, a technical how to book that actually delivers more than it claims on the cover. It is unintimidating, easy to read, and there s a really useful nugget of information on almost every page. As an example, although ostensibly focused only on Excel Macro programming, this book along the way clarifies some critical details on both Excel Pivot Tables and R1C1 cell referencing that another 850-page comprehensive book on Excel completely failed to mention.

VBA & Macros for Excel - Mr Excel has written yet another great book about Excel, over 500 pages of highly informative stuff, great examples and its all written in an easy to use format.(The explanation of VBA speech is great.)As a Excel power user for several years I m always looking for something to give me the edge and make mine or my co-workers life that little easier. This book does, as do the rest of the Mr Excel / Holy Macros titles.Want to learn VBA - Go Buy!!




VBA and Macros for Microsoft Excel (Business Solutions)