Writing Excel Macros with VBA, 2nd Edition by Steven Roman (PDF)

Description

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 on:The Visual Basic Editor and the Excel VBA programming environment. Excel features a complete, state-of-the-art integrated development environment for writing, running, testing, and debugging VBA macros.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.

User’s Reviews

Editorial Reviews: About the Author Steven Roman, Ph.D., is a professor emeritus of mathematics at the California State University, Fullerton. His previous books with O’Reilly include “Access Database Design and Programming”, “Writing Excel Macros with VBA”, and “Win32 API Programming with Visual Basic”.

Reviews from Amazon users which were colected at the time this book was published on the website:

⭐I want to learn how to program using VBA. The author seems to constantly imply what a great programmer he is and that you as a new or intermediate user of VBA do not need any examples of VBA code to learn the language.

⭐Mr Roman is an extremely competent and clear writer. This book, whilst not as big as some, doesn’t waste space with any padding, and boring repititious stuff you see in some texts.Although there could have been a little more on interplay between Excel and the other Office objects, esp. Outlook, this book makes up for that with its clear, organised and logical presenatation.I use it as a reference book, and seem to remember the content of it more clearly than I do with other comparable books! Why is this? Mr Roman has a tidy turn of phrase, doesn’t wafffle, but his explanations seem to sit well in how my mind works. I hope this will be the same for you. I recommend this book for those who may be beyond the beginner stage of learning VB(A). It also includes some handy utilities for users of Excel.Mr Roman – well done. Look forward to your next (high level?) Excel VBA book.

⭐There are a number books on VBA and on programming Excel with VBA. Some of these are quite good and have many useful examples. However, once one understands the basic techniques, accomplishing one’s goal primarily requires detailed knowledge of the Excel object model. One can dig through the object browser and/or the Microsoft documentation for this information or use the macro recorder as a ‘prototyping’ shortcut, but these techniques are somewhat time consuming and are less than complete.This book’s coverage of the Excel object model is by the far the best I have seen and is well organized and through. It explains the intent of the properties and methods rather than just explaining the syntax.The author also details various caveats about how various components within the object model operate. This is very useful. As a simple example, he explains that setting the Chart objects .HasAxis property before the Chart has any data series defined will result in a cryptic error that is not covered in the documentation. Without this information one might end up blindly copying some ugly code from the macro recorder that seems to work though it wouldn’t be clear just why this code worked while the other method failed.If one is not already very knowledgeable of Excel and VBA, this book would probably work best accompanied by a book like Walkenbach’s, “Excel 2003 Power Programming with VBA”. Eventually however, this will probably become the “goto” reference.

⭐The author states that he doesn’t mince words or beat around the bush with certain concepts, and he proves to be a man of his word. This is probably more appropriate for macro writers with a little experience. If you’re new to programming, you’re probably better off in the world of Mr. Walkenbach, who understands that people are either new to programming or under a time cruch, and that sometimes a few explicit examples or extra explanation is appropriate. I own both authors and use both regularly. All in all, a solid reference for the right audience.

⭐This book is kind of old and I believe there should be a lot better tutorials in this area. However, it is cheap and affordable. The paper quality and layout are poor and papers may get detach from the book cover easily.

⭐Very good, lil on rambly side but explained well.

⭐Seems outdated, but works perfectly in my excel 2016. Remember that vba its not like C++ or even Python, it doesn’t change as much.

⭐Just realize this is a pretty outdated version of the book before you pull the trigger

⭐I enjoyed this book for learning more about VBA

⭐Very good

⭐This is the book you need if you are new to VBA.. OR even if you have a fair amount of knowledge in the subject!

Keywords

Free Download Writing Excel Macros with VBA, 2nd Edition in PDF format
Writing Excel Macros with VBA, 2nd Edition PDF Free Download
Download Writing Excel Macros with VBA, 2nd Edition 2002 PDF Free
Writing Excel Macros with VBA, 2nd Edition 2002 PDF Free Download
Download Writing Excel Macros with VBA, 2nd Edition PDF
Free Download Ebook Writing Excel Macros with VBA, 2nd Edition