VBA and Macros for Microsoft Excel (Business Solutions) | 
 enlarge | Authors: Bill Jelen, Tracy Syrstad
Publisher: Que
Category: Book
List Price: $39.99
Buy New: $23.05
You Save: $16.94 (42%)
New (31) Used (14) from $19.00
Avg. Customer Rating:  16 reviews
Sales Rank: 58328
Media: Paperback
Number Of Items: 1
Pages: 576
Shipping Weight (lbs): 2.2
Dimensions (in): 9 x 7.4 x 1.3
ISBN: 0789731290
Dewey Decimal Number: 005.54
UPC: 029236731298
EAN: 9780789731296
ASIN: 0789731290
Publication Date: May 20, 2004
Availability: Usually ships in 1-2 business days
Shipping: Expedited shipping available
Condition: Brand New. US edition ISBN 0789731290. Buy with confidence from a 100% rating seller. Mailed from Chicago, IL by the next business day with a tracking number. Expedited shipping available as an extra option through Amazon.
|
| Editorial Reviews:
Product Description
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!
Download Description
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!
|
| Customer Reviews: Read 11 more reviews...
 The best book on the subject September 29, 2007
1 out of 3 found this review helpful
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.
happy transaction September 15, 2007
0 out of 3 found this review helpful
I am very satisfied with the transaction. The shipment was on time and the product is in good quality
Useful July 12, 2007
1 out of 1 found this review helpful
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.
Impressive! A wealth of key information and examples October 3, 2006
5 out of 5 found this review helpful
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!
 Somewhat disjointed June 25, 2006
13 out of 15 found this review helpful
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.
|
|
|
