Writing Excel Macros: Automating Excel to Work for You

Steven Roman, PhD

ISBN 10: 1565925874 / ISBN 13: 9781565925878

Published by OReilly Media, 1999

About this Item

Dispatched, from the UK, within 48 hours of ordering. Though second-hand, the book is still in very good shape. Minimal signs of usage may include very minor creasing on the cover or on the spine. Seller Inventory # CHL4158862

Bibliographic Details

Title: Writing Excel Macros: Automating Excel to ...

Publisher: OReilly Media

Publication Date: 1999

Binding: Paperback

Condition: Used; Very Good

About this title

Synopsis:

Despite Microsoft Excel's powerful feature set, there is a great deal that it either does not allow you to do or does not allow you to do easily through its user interface. Writing Excel Macros offers a solid introduction to writing VBA macros and programs in Excel and shows you how to get more power our of Excel at the programming level. It thoroughly covers the essentials of the VBA language and the Excel object model so that by the time you have finished, you will know enough about Excel VBA to begin creating effective working programs. Learn how to get the most out of this formidable application as you focus on programming languages, the Visual Basic Editor, handling code, and the Excel object model. You'll learn how to use macros to perform repetitive tasks, provide simple keystroke access to some features, or implement functionality that is not readily available using Excel formulas. Includes numerous examples.

Reviews:

In terms of environments, you can't get any more programmable than Microsoft's Excel spreadsheet. There are lots that can be done with the built-in functions, but programmers still need functionality not designed into the system. Users unaccustomed to writing macros will be lost in macro programming hell if they don't have Roman's book. Roman assumes his readers are already real programmers but not yet familiar with the Excel object model and Visual Basic for Applications (VBA). His manual starts first with an introduction and then includes a discussion of the Visual Basic Editor and the VBA language and practical examples of the Excel object model. Definitely not for beginners, this is written specifically for Microsoft Version 8 (Office 97) and Version 9 (Office 2000).
Copyright 1999 Reed Business Information, Inc.