Using Excel Visual Basic for Applications, Special Edition (Using ... (Que)) | 
 enlarge | Author: Jeff Webb
Publisher: Que
Category: Book
List Price: $44.99
Buy Used: $1.16
You Save: $43.83 (97%)
New (26) Used (24) from $1.16
Rating:  14 reviews
Sales Rank: 493881
Media: Paperback
Edition: 2 Sub
Pages: 868
Number Of Items: 1
Shipping Weight (lbs): 3.6
Dimensions (in): 9.1 x 7.4 x 1.9
ISBN: 078970269X
Dewey Decimal Number: 005.365
EAN: 9780789702692
ASIN: 078970269X
Publication Date: January 1996
Availability: Usually ships in 1-2 business days
Shipping: Expedited shipping available
Shipping: International shipping available
Condition: Millions of satisfied customers and climbing. Thriftbooks is the name you can trust, guaranteed. Spend Less. Read More.
| |
| Similar Items:
|
| Editorial Reviews:
Product Description
Updated to cover all the new features of VBA language and how to build robust applications with each of the pieces of Microsoft Office, this book leads the reader through the process of recording and modifying macros, introduces the reader to VBA language, and explains how to create stand-alone Windows applications.
|
| Customer Reviews: Read 9 more reviews...
 Congratulations March 30, 2007
Darlon Destri (Brazil)
Thank you very much. This was the first time that I had purchased something out of my country by Internet and every thing was attended. I would say to keep their work with this philosophy.
The Best Written Book I own for Visual Basic/Studio/App March 31, 2005
Joe Bruin (Home of the Bruins!)
8 out of 8 found this review helpful
I own nearly a dozen books on Visual Studio(VS), Visual Basic(VB), and Visual Basic for Applications(VBA). For the past 3 years, I have architected personal / workplace solutions, and have been mostly self-taught through books and online learning opportunities.
After finding "Using Excel Visual Basic For Applications," by Jeff Webb, it has become hands-down my primary resource. "The Excel Bible," by John Walkenbach used to be my book of choice, but where Walkenbach concentrates more on explaining Excel, Jeff Webb has developed his effort to elaborate on VBA, and is focused on object-oriented programming.
For instance, Chapter 5 of 21 includes a section on the 'Application Object.' Starting with an explanation of what is an Application Object, a chart spanning three pages, consisting of 'Properties and Methods' applicable to an Object follows. It is analogous to VB's Object Browser, since both provide the Developer a directory listing. Then Jeff Webb steps into each entry and provides explanations of what happens to the object, like VB Help, and a code snippit. For example:
[Application.]ActiveCell
Bracketed items being optional, this example would mean the snippit is merely 'ActiveCell', and can be inserted into the code of a function or subroutine ie.
Sub Subname()
ActiveCell
Exit Sub
This procedure will return the range of where the Excel cursor is, also known as the "Input Focus."
If what you have just read makes sense to you but don't understand, you could benefit from owning "Using Excel Visual Basic for Applications." If there is no comprehension, I suggest reading, 'Microsoft Office Excel 2003 Bible' by John Walkenbach from WILEY Publishing.
PS. I am not affiliated with QUE, Jeff Webb, WILEY, or John Walkenbach, and did not receive any compensation for this commentary about either book, just in case the thought occurred...
 Hopelessly out of date October 14, 2004
Elma Van Der Ryst (USA)
This book is just not useful anymore. The code is old and the dialog boxes don't look or function the same anymore. I'm not new to programming, but a beginner would be totally lost. As it is I am going to send this one back and get a more up to date one, just in case I can't jam my way out of it. There also might be (and probably are) newer features not covered in this book.
Aside from that, it looks as if it could have been a great book in its time. When are you guys going to publish an up to date one?
Useless, useless, useless and what happened to English... June 5, 2001
4 out of 11 found this review helpful
I had some elementary knowledge about VB beforehand and I borrowed this book from a friend in order to look up certain things. I found it to be useless and hard to read. It might be just me, but if I wanted to buy a book on VB and Excel I would stay very far, far, far and AWAY from this one.
Code doesn't work April 12, 2001
4 out of 5 found this review helpful
I have some knowledge of VB and wanted to get a look at VBA, so a friend loaned me this book. It seems to be very complete and well organized, but so far the code examples I have tried don't work. This may be because I am using Excel 2000 and the book was written in 1996. I have been able to make the code samples work by just fiddling with the code until it runs. However, this is a frustrating experience for someone who likes to learn hands on, and would probably be a disaster for a brand-new programmer.
|
|
|
