Writing Excel Macros: Automating Excel to Work for You

by Steven Roman

Microsoft Excel is an enormously powerful and flexible application. Yet despite its powerful feature set, there is a great deal that Excel either does not allow you to do or does not allow you to do easily through its user interface. And in spite of Excel's reputation as the most widely used spreadsheet application, the majority of its users do not venture beyond the basics of creating spreadsheets and perhaps dabbling with macros. Consequently, these users aren't getting all the power out of this formidable application.With Writing Excel Macros you will learn there are many things you can do at the programming level that you cannot do at the user-interface level, that is, with the menus and dialog boxes of Excel. And learning how to get more power out of Excel will mean you can be more effective in your work. Writing Excel Macros offers a solid introduction to writing VBA macros and programs and provides Excel users and programmers unfamiliar with the Excel object model with an excellent overview to writing VBA macros and programs. The essentials of the VBA language and the Excel object model are covered so that, when you have finished the book, you will know enough about Excel VBA to begin creating effective working programs.In particular, the book focuses The information in this book is written in a succinct, practical manner that is characteristic of Steve Roman's straightforward approach. Readers will find useful examples throughout the book that deal with specific programming problems and allow them to gain hands-on experience in the VBA environment. Whether your interest in Excel programming is so you can be more effective in your work, or you want to learn how to write Excel programs for others to use, this book offers a solid introduction to writing VBA macros and programs and shows you how to get more power out of Excel at the programming level.

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

554 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