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 on:
Programming languages. Brief overview of programming and programming languages, as well as information on Variables, Data Types, and Constants, Functions and Subroutines, and more.
The Visual Basic Editor. Before tackling the basics of the programming language that Excel uses, the reader is acquainted with the VBA environment--the Visual Basic Editor.
Handling your code. An overview of where to store your code and how to activate it from an Excel spreadsheet.
The Excel object model. An in-depth overview of the Excel object model, including the Application, Workbook, Worksheet, and Range objects.
Appendices. Details on the Shape object; getting the Installed Printers; Command Bar Controls and Face IDs; programming Excel from another application; and more.
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.
Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal on the cover of Writing Excel Macros is a bluejay (Cyanocitta cristata), a vociferous, aggressive bird common in the eastern half of the United States and southern Canada. The blue-crested jay is also an agile flyer and occasional nest-robber. The term "bluejay" is also applied to the Steller's jay (Cyanocitta stelleri), a larger, darker jay common in much of the western U.S. and Canada, as well as several other species. Bluejays eat primarily nuts, seeds, and insects, sometimes planting acorns in the ground, thus helping tree growth. Known for their loud, harsh, and easily identifiable calls, bluejays (related to crows and ravens) often spoil the hunting forays of other animals by warning potential prey. Bluejays are bright blue, white, and black, with both sexes similar in appearance. They are about 10inches in length, and build large tree nests about 25 feet off the ground, into which are laid 3spotted olive-colored eggs. The male is very attentive during the nesting periods. Jays are sociable and frequently travel in groups ranging from a mating pair to a larger flock. Clairemarie Fisher O'Leary was the production editor and copyeditor for Writing Excel Macros ; Sheryl Avruch was the production manager; Jeffrey Liggett, Sarah Jane Shangraw, and John Files provided quality control. Robert Romano created the illustrations using Adobe Photoshop 5 and Macromedia FreeHand 8. Mike Sierra provided FrameMaker technical support. Ruth Rautenberg wrote the index. Hanna Dyer designed the cover of this book, based on a series design by Edie Freedman. The image is a 19th-century engraving from the Dover Pictorial Archive. The cover layout was produced by Kathleen Wilson using QuarkXpress 3.3 and the ITC Garamond font. The inside layout was designed by Alicia Cech, based on a series design by Nancy Priest and implemented in FrameMaker 5.5.6 by Mike Sierra. The text and heading fonts are ITC Garamond Light and Garamond Book. This colophon was written by Nancy Kotary.
Hanna Dyer designed the cover of this book, based on a series designed by Edie Freedman. The image is based on a 19th-Century engraving from the Dover Pictorial Archive. The cover layout was produced by Kathleen Wilson using QuarkXpress 3.3 and the ITC Garamond font. The inside layout was designed by Alicia Cech, based on a series design by Nancy Priest.
I bought this book simply because it was published by O'Reilly. What a mistake. In over ten years, I've collected something like 30 O'Reilly books and every single one of them has been a superb reference or teaching aid.
This book changed everything and from now on I will be reading reviews from a variety of sources before spending another penny on O'Reilly books.
The book needs a decent project that builds up throughout and the examples to provide both simple and complex demonstrations of the language and object model. Most of the examples in the book were exactly what i can find by pressing F1!
It doesn't even cover the entire object model? Why? Another 50 pages and the entire Excel object model could have been fully documented.
All in all, very let down by a publisher that once meant an instant purchse for me.
I am only in the middle of the book. But I can't wait to draw other attention that this book is the good stuff I am looking for years. As a beginner (I used Lotus Symphony before) of Excel, I have great difficult to transcript all my macro created under Lotus to Excel. This book give me right guidance to start with and now I can almost make use all my previous
I am a construction estimator by profession and am
studying part time for a computer science degree. I use Excel on a daily basis and have found this book to be of tremendous use in assisting with my comprehension of VBA and in particular the Excel object model. The hands on approach and worked examples are challenging, rewarding and, once mastered, extremely relevant. I look forward to the challenge of further titles from Steven Roman and others published under the O'Reilly banner.