ComicsChildrenHumorFitnessReferenceITLawCookingHobbiesTeachingSelf-HelpPhotoFantasyHistoryTestsCalendarsFictionLGBTTeenagersTransportMemorisMedicineMysteryRelationshipsPoliticsBusinessSpiritualityRomanceBiblesMathSportTravelOtherNo category
» » Definitive Guide to Excel VBA
Definitive Guide to Excel VBA e-book

Author:

Michael Kofler

Language:

English

Category:

IT

Subcategory:

Programming

ePub size:

1986 kb

Other formats:

lrf lit mobi rtf

Rating:

4.2

Publisher:

Apress; 1 edition (November 2000)

Pages:

866

ISBN:

1893115798

Definitive Guide to Excel VBA e-book

by Michael Kofler


Designed to be useful to programmers who have never used VBA before, it also covers advanced topics needed for users already familiar with VB. irst, Kofler introduces VBA and the Excel object model, focusing on the unique characteristics of programming and debugging code associated with spreadsheets.

Kofler's book offers more up-to-date coverage than other books on the market - Provides in-depth coverage of topics normally . Michael Kofler holds a P. in computer science from Graz Technical University in Austria.

Kofler's book offers more up-to-date coverage than other books on the market - Provides in-depth coverage of topics normally overlooked. He has written a number of successful computer books on topics such as Visual Basic, Visual Basic. Series: Definitive Guides (Paperback). Paperback: 936 pages.

First, Kofler introduces VBA and the Excel object model, focusing on the unique .

First, Kofler introduces VBA and the Excel object model, focusing on the unique characteristics of programming and debugging code associated with spreadsheets. The next few chapters cover menus, toolbars, forms, and templatesthe tools for creating customized user interfaces and full-featured applications. Throughout the book, Kofler never loses sight of the real-world problems faced by Excel programmers. Show all. Table of contents (15 chapters).

Covering a variety of Excel simulations by using Visual Basic (VBA), from gambling to genetics. This book provides a comprehensive introduction to modern financial modeling using Excel, VBA. 21 MB·13,526 Downloads·New!. 17 MB·37,323 Downloads. EXCEL VBA programing. 09 MB·33,832 Downloads. Chapter 1 Visual Basic for Applications with Excel . .147 vi. Microsoft Excel VBA Programming.

Start by marking Definitive Guide to Excel VBA as Want to Read .

Start by marking Definitive Guide to Excel VBA as Want to Read: Want to Read savin. ant to Read. First, Kofler introduces VBA and the Excel object model, focusing on the unique characteristics of programming and debugging code associated with spreadsheets.

Michael Kofler holds a P. in computer science from Graz Technical University. Michael is the author of Definitive Guide to Excel VBA and MySQL, both from Apress.

Microsoft Excel (Computer file), Microsoft Visual Basic for applications. Computer software - Development. Electronic spreadsheets. inlibrary; printdisabled; ; china.

Trademarked names may appear in this book

Trademarked names may appear in this book.

Want to be notified of new releases in excel-vba? . Release v. corresponds to the code in the published book, without corrections or updates.

Release v. See the file Contributing. md for more information on how you can contribute to this repository.

In this book, Michael Kofler provides definitive coverage of Visual Basic for Applications (VBA) for Excel by showing how it can be used to implement real-world business solutions. Designed to be useful to programmers who have never used VBA before, it also covers advanced topics needed for users already familiar with VBA.

First, Kofler introduces VBA and gives examples of the kinds of tasks that it can perform. He then introduces the Excel object model, focusing on the unique characteristics of programming and debugging code that are associated with spreadsheets. The next few chapters cover menus, toolbars, forms, and templatesthe tools for creating customized user interfaces and full-featured applications. Kofler then moves on to a broad range of advanced topics, including automating graphs and diagrams, accessing external databases from Excel, and analyzing data using grouping and pivot tables. He even covers Excel-related features of Office Developer, such as the development of COM Add-Ins.

Throughout the book, the author never loses sight of the real-world problems faced by Excel programmers. The book also explores ways to avoid undocumented problems that may arise when programming Excel VBA practical knowldege that was gained through years of hard experience.


Road.to sliver
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".
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. 343-695 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 hand-holding 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.
Domarivip
Compared to Walkenbach books (like Excel 2002 / 2000 power programming with VBA) and many others, this book is truly worth its title. Its clear and very well structurated plan means all information can be found easily and everything understood without pain. This is paramount since a book main and unique goal is to transmit information. Its design and layout, clear, eye-pleasing and professional, strengthens this crucial aspect. With Walkenbach, the reader has to collect elements throughout all chapters them combine them to get an idea of a particular topic!!! With this book, the reader knows what he'll find and where. For example, all error handling is included in one part while all functions are sorted by theme (math, date etc.) It's incredible that having a coherent and clear organization, which should be basic, is not in Walkenbach books!?
Furthermore, this book reveals many important and little documented points tied to Excel VBA, ranging from range and cells to many critical points like external data access with true database programs, which are even not dealed in some self-proclamed 'expert' books, like Walkenbach's. Besides, it exhibits many trips and tricks that allow fast, clean programs and avoir many troubles by grouping all points linked to a particular problem.
Third, the writting is not terse: with irony, and a great amount of objectivity, qualities which seem to evaporate in Walkenbach and others (which very often sound like a Microsoft ad), it clearly explains and demonstrates the limits and bugs of Excel VBA.
Fourth, the companion CD Rom is truly useful, loaded with many pratical and real-life examples and solutions. Again, Walkenbach, after saying virtually every page the HE is the author, the creator and so forth, with its constant I-do-this mentality, provides a software wich is not usable since the reader has to send a coupon card!
Finally, this is the book to have for truly mastering Excel VBA, without pain but with efficiency.
Jia
When I purchased this book I assumed that because I have some VB experience and am fairly well versed with Excel that this book would fill the gap for me to pick up VBA. Sadly, this was not the case. Specifically, the nuts and bolts of interest to a VBA beginner are for the most part placed in one mammoth 150 page chapter. The frustrating subject of addressing and manipulating ranges, especially across sheets, is not covered in any depth. Example code is scarce and I couldn't get some of the sample code to work at all. Some of the language is convoluted possibly a result of being translated from the original german. In fairness, I did not get much past chapter 5 so perhaps once I'm up to speed the rest of the book may prove more helpful. Also the index is quite good especially compared to some other computer books I've seen.
If you're a beginner I would recommend J. Walkenbach's website on VBA for Excel. Also, chapter 14 of "Excel For Chemists" by E.J. Billo is an excellent source for learning how to reference ranges.

e-Books related to Definitive Guide to Excel VBA