Writing Excel Macros with VBA, 2nd Edition

by Steven Roman, Steven Roman

Newly updated for Excel 2002, Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel. In particular, the book focuses The VBA programming language, the same programming language used by the other applications in Microsoft Office XP and 2000, as well as by the retail editions of Visual Basic 6.0. The Excel object model, including new objects and new members of existing objects in Excel 2002. Excel exposes nearly all of its functionality through its object model, which is the means by which Excel can be controlled programmatically using VBA. While the Excel object model, with 192 objects, is the second largest among the Office applications, you need to be familiar with only a handful of objects to write effective macros. Writing Excel Macros focuses on these essential objects, but includes a discussion of many more objects as well. Writing Excel Macros with VBA, 2nd Edition is written in a terse, no-nonsense manner that is characteristic of Steven Roman's straightforward, practical approach. Instead of a slow-paced tutorial with a lot of handholding, Roman offers the essential information about Excel VBA that you must master to write macros effectively. This tutorial is reinforced by interesting and useful examples that solve common problems you're sure to have encountered. Writing Excel Macros with VBA, 2nd Edition is the book you need to delve into the basics of Excel VBA programming, enabling you to increase your power and productivity.

Genres: Programming, Reference, Computers, Nonfiction, Technical, Technology, Computer Science

570 pages, Paperback

First published January 1, 1999

Reviews

[Clare · Rating 5 out of 5]

This is an outstanding book. I can't remember any VBA to save my life - it just slips out of my brain - so I use this as a quick reference. It's one of the best programming texts I've ever encountered, if one can describe VBA as "programming" with a straight face.

[Joe Michalak · Rating 4 out of 5]

This book is great in providing a thorough overview of the MS Excel VBA coding module. It tends to lean towards being more of a reference tome than a true learning book, but the embedded examples help.

It should be noted that this book came out in 2002, and many of the topics/chapters are outdated. For instance, the ribbon wasn't even a thing when this book came out. (Think Excel XP).

That said, most of the code is still in use and relevant (at least within the context of VBA).

[Sherpa · Rating 4 out of 5]

I ended up buying this book for my Logistics internship, and it proved invaluable. If you already had some experience with programming then you'll have no problem understanding every piece of this, as it is written for easy reading. As with many programming language references, it's just a basic rundown of all the main functions of the Excel VBA. If you're comfortable with material like this, and you often create reports/give presentations at your jobs, it really is a great skill to learn. Pretty good book. Recommended.

[Rachael · Rating 1 out of 5]

i believe the book was returned to my bf's boss before i could finish, which is fine, since i really didn't like the style in which it was written. instead of having a starting point and building on it and compounding from there, it really just bounced all over the place from subject to subject, with occasional notes reminiscent of things like "we'll get to that part later".

i'll likely pick up a different book on the subject at a later date, hopefully one written in a more sequential manner.

[Francesco · Rating 3 out of 5]

Ottima lettura per iniziare il VBA, e da consultare quando non ci si ricorda come fare un certo procedimento.

[AISV6 SENIOR LIBRARY]

GG6 DL026669

[Delhi Irc]

Location: GG6 IRC
Accession no: DL026669