Vba and Macros for Microsoft Excel (Business Solutions)

  Author:    Bill Jelen, Tracy Syrstad
  ISBN:    0789731290
  Sales Rank:    68781
  Published:    2004-05-01
  Publisher:    Que
  # Pages:    608
  Binding:    Paperback
  Avg. Rating:    4.0 based on 17 reviews
  Used Offers:    19 from $23.37
  Amazon Price:    $25.99
  (Data above last updated:  2008-09-04 04:34:47 EST)
  
  
Sort customer reviews by:
  
Show All Reviews on Page      Hide All Reviews on Page
   
  
Vba and Macros for Microsoft Excel (Business Solutions)
  

Everyone is looking for ways to save money these days. That can be hard to do for businesses that have complex needs, such as custom software applications. However, VBA and Macros for Microsoft Excel can teach you ways to customize pre-existing software to meet your specific needs. A variety of topics are covered that are sure to give you a solid knowledge of the VBA language. Event programming, user forms, carts, pivot tables, multi-dimensional arrays and Web queries are just a few of the areas you will learn about in this book. Written by the principal behind the leading Excel Web site, www.mrexcel.com, this book is sure to save you time and money!

Microsoft Visual Basic for Applications (VBA) is a powerful development technology for customizing desktop applications and integrating them with existing data and systems, enabling customers to buy off-the-shelf software and customize it to meet their specific needs. This is a big cost-saving solution for most business who cannot afford to build programs from scratch. There are an estimated 65 million Excel users. Many are Excel power users, but few have figured out how to effectively use Excel VBA. This book teaches the skills necessary to use Microsoft VBA to customize the Excel spreadsheet. No prior programming knowledge is assumed. It takes a reader who has, perhaps, built a couple of macros from a standing start to a complete knowledge of the VBA language. Topics covered include: event programming, user forms, charts, pivot tables, Web queries, multi-dimensional arrays, classes, records, and collections, and more!
                  Reader Reviews 1 - 12 of 12                 
  
  
Review
Date
Review
Rating(5 High)
Review
Helpful
to:
Customer Review Reviewer
Info
Permanent
Link
Reader Reviews Below Sorted by Newest First
07-02-08 1 2\4
(Hide Review...)  Run the other way...quickly!!
Reviewer Permalink
If I could give 0 stars, I would.

This book is poorly written and poorly edited...and I have the version "Reprinted with corrections." Flipping through it in the bookstore, it seemed promising - enough so that I actually bought it. After three chapters, however, I am ready to throw in the towel.

This is a technical book. It's about programming. It contains examples of actual code. The examples have to be correct to have any credibility. Once you lose that, every line becomes suspect. Let me provide you just a few examples.

On page 32, the colorindex for "yellow" is given as "6"; on page 33 it is "30".
On page 41, "Selection is actually a property and not an object." When I reach page 50, "Selection" has become an object again.
On page 62, in the third example within Table 3.1, the delimiting comma is inside the quotes.
On 67, " Notice that that the offset..."
Also on that page, the resizing example at the bottom is wrong. If I have a column and add two more to it, I end up with three. Maybe Mr. Excel is using a higher level of math when he says "Range("Produce").Resize(,2) and says "Remember, the number you resize by is the TOTAL number of rows and/or columns you want to include."

What really rolled my eyes back in my head was on page 63, when I encountered .range(.range, range) with insufficient introduction. A relatively simple statement with a single range reference suddenly morphed into a triple range reference with an indecipherable comment about "an extra range at the beginning of the code line." This makes absolutely no sense, and coupled with the authoring or editing miscues mentioned earlier, it is not even possible to determine if this is a typo or simply a badly written passage.

Whether I ultimately can gain any value from this book remains to be seen - assuming I am able to actually make sense of the content. For me, it was a total waste of the purchase price.
(Review Data Last Updated: 2008-09-02 07:00:58 EST)
09-30-07 5 1\1
(Hide Review...)  The best book on the subject
Reviewer Permalink
Bill Jelen is a brilliant self-promoter. His book is even more brilliant. His newsgroup, MrExcel Message Board Forum at www.mrexcel.com, is an invaluable resource.
(Review Data Last Updated: 2008-01-30 07:06:22 EST)
09-29-07 5 1\3
(Hide Review...)  The best book on the subject
Reviewer Permalink
Bill Jelen is a brilliant self-promoter. His book is even more brilliant. His newsgroup, MrExcel Message Board Forum at www.mrexcel.com, is an invaluable resource.
(Review Data Last Updated: 2008-06-30 04:58:13 EST)
09-15-07 5 0\2
(Hide Review...)  happy transaction
Reviewer Permalink
I am very satisfied with the transaction. The shipment was on time and the product is in good quality
(Review Data Last Updated: 2007-12-15 06:55:51 EST)
07-12-07 4 1\1
(Hide Review...)  Useful
Reviewer Permalink
The book is useful. The worksheets downloaded from the Internet are also very clear.
Sometimes you expect more explanations on statements which use new features not connected with the subject being reviewed.
I think that I shall not need to purchase any other book on this subject.
(Review Data Last Updated: 2007-12-15 06:55:51 EST)
10-04-06 4 3\3
(Hide Review...)  Impressive! A wealth of key information and examples
Reviewer Permalink
I found this book to be one of the best references for Excel VBA development. The book is easy to understand and follow. Contains a large amount of examples that can be easily understood. Addresses many critical aspects of excel VBA development. Not too much was spent on forms/GUI development so you will have to look elsewhere if you into that. Also addresses interfacing Excel to databases using ADO as well as API programming which is critical for superusers to extend the power of excel without the limitation of data storage. Overall, the authors have a superb job and I consider this book to be an essential of my Excel VBA library!
(Review Data Last Updated: 2007-12-15 06:55:51 EST)
10-03-06 4 2\2
(Hide Review...)  Impressive! A wealth of key information and examples
Reviewer Permalink
I found this book to be one of the best references for Excel VBA development. The book is easy to understand and follow. Contains a large amount of examples that can be easily understood. Addresses many critical aspects of excel VBA development. Not too much was spent on forms/GUI development so you will have to look elsewhere if you into that. Also addresses interfacing Excel to databases using ADO as well as API programming which is critical for superusers to extend the power of excel without the limitation of data storage. Overall, the authors have a superb job and I consider this book to be an essential of my Excel VBA library!
(Review Data Last Updated: 2007-04-11 07:41:13 EST)
06-25-06 3 12\13
(Hide Review...)  Somewhat disjointed
Reviewer Permalink
The first few chapters were a reasonable introduction to VBA for Excel, but after that, the examples, while being quite relevant and useful, seemed somewhat random, and did not strike me as being well supported by the text.

I think that those who are looking for an abundance of code examples will be reasonably happy. The book is full of code handling tasks that most Excel VBA programmers will need to find solutions to. Those looking for a tutorial, for examples of good coding practice and principles, and an understanding of the underlying principles of VBA in the Excel environment, should probably look elsewhere.

Walkenbach's Power Programming is excellent. VBA for Modelers, by Albright, is a book that does a great job of combining theory and practical code examples for me. For people looking for advanced material, Excel with VBA & .NET by Jeff Webb, and Professional Excel Developement by Bullen, Bovey and Green are very good.
(Review Data Last Updated: 2007-12-15 06:55:51 EST)
06-16-06 5 3\3
(Hide Review...)  Very good book
Reviewer Permalink
I highly recommned this book for people writing Excel macros and VBA. Very well organized and nice snappy text keeps you engaged and going. Lots of good code too. It is an intermediate level text.
(Review Data Last Updated: 2007-12-15 06:55:51 EST)
03-20-06 5 1\3
(Hide Review...)  Great First Book for Writing Macros
Reviewer Permalink
This is a great book for getting started.

I recommend it to all my friends and business associates who want to get started writing macros for excel.
(Review Data Last Updated: 2007-07-04 06:54:16 EST)
02-10-06 5 3\5
(Hide Review...)  Great examples, very useful for problem solving.
Reviewer Permalink
This book is not a basic level book. You must have a good basic knowledge of VBA and Macros in Excel. If you are experienced, and need to perform tasks you have not performed to before, this book is an absolute must. Not for the novice.
(Review Data Last Updated: 2007-07-04 06:54:16 EST)
09-01-05 1 7\32
(Hide Review...)  Don't bother - plain and simple.
Reviewer Permalink
This book is pure junk. The mistakes and errors are shameful and disappointing.

Be careful of the other reviews, they are all from associates of the author.
(Review Data Last Updated: 2007-07-04 06:54:16 EST)
  
                  Reader Reviews 1 - 12 of 12                 
  
  
  
  
  
  

Because the data used to generate this site come from outside sources, VeryWellSaid.com cannot guarantee the completeness or accuracy of the data.
Search VeryWellSaid™
Google
Web VeryWellSaid™
New subjects are added every week.
View Subjects Below by:
* Top Selling
 (click category name, left)
* Top-Rated Top Sellers
 (click 'Top Rated', right)
In the news...  
Dubai\UAE Top Rated
Influenza\Bird Flu Top Rated
Iraq Top Rated
Supreme Court Top Rated
All Books Top Rated
Arts Top Rated
Photography Top Rated
Digital Photography Top Rated
Digital Cameras Top Rated
Biography Top Rated
Business Top Rated
Management Top Rated
Marketing Top Rated
Sales Top Rated
Stocks Top Rated
Bonds Top Rated
Real Estate Top Rated
Trading Top Rated
Commodities Trading Top Rated
Time Management Top Rated
Starting A Business Top Rated
Children's Top Rated
Comics Top Rated
Computers Top Rated
PC Top Rated
Mac Top Rated
Programming Top Rated
Design Patterns Top Rated
.Net Top Rated
C# Top Rated
Vb.Net Top Rated
Asp.Net Top Rated
Java Top Rated
Python Top Rated
PHP Top Rated
Perl Top Rated
Javascript Top Rated
Ajax Top Rated
CSS Top Rated
Open Source Top Rated
SQL Top Rated
Databases Top Rated
Oracle Top Rated
MySql Top Rated
Sql Server Top Rated
IIS Top Rated
Apache Top Rated
Linux Top Rated
Windows Server Top Rated
Project Management Top Rated
HTML Top Rated
UML Top Rated
IT Certifications Top Rated
Cisco Certifications Top Rated
MCSE Top Rated
MCSD Top Rated
Cooking Top Rated
Italian Cooking Top Rated
Vegetarian Cooking Top Rated
Wine Top Rated
Engineering Top Rated
Entertainment Top Rated
Health Top Rated
Nutrition Top Rated
Dieting Top Rated
Sex Top Rated
History Top Rated
Military History Top Rated
British History Top Rated
Middle East History Top Rated
Land Battles Top Rated
Naval Warfare Top Rated
Air Warfare Top Rated
9/11 Top Rated
Terrorism Top Rated
Home Top Rated
Mortgage\Home Equity Loan Top Rated
Cars Top Rated
Car Buying Top Rated
Sports Cars Top Rated
Cat Top Rated
Humor Top Rated
Horror Top Rated
Law Top Rated
IP Law Top Rated
Legal History Top Rated
Fiction Top Rated
Oprah's Book Club Top Rated
Medicine Top Rated
Cancer Top Rated
Stroke Top Rated
Heart Disease Top Rated
Fertility Top Rated
Diabetes Top Rated
Pharmacology Top Rated
Back Problems Top Rated
Menopause Top Rated
Thyroid Top Rated
Pain Top Rated
Organic Chemistry Top Rated
Immune System Top Rated
Mystery Top Rated
Nonfiction Top Rated
Outdoors Top Rated
Running Top Rated
Radio Control Models Top Rated
Guns Top Rated
Parenting Top Rated
Divorce Top Rated
Professional Top Rated
Reference Top Rated
Religion Top Rated
Romance Top Rated
Science Top Rated
Physics Top Rated
Chemistry Top Rated
Astronomy Top Rated
Psychology Top Rated
Science Fiction Top Rated
Sports Top Rated
Teens Top Rated
Travel Top Rated
USA Top Rated
Europe Top Rated
France Top Rated
Italy Top Rated
England Top Rated
China Top Rated
All Books Arts Biography Click Here For An A-Z Index Of All 213 Best-Seller Subjects Business Children's Comics
Computers Cooking Engineering Entertainment Health History Home Horror Humor Law Fiction Medicine Mystery
Nonfiction Outdoors Parenting Professional Reference Religion Romance Science Sci-Fi Sports Teens Travel
In Association with Amazon.com

Cache miss
(not cached)