Writing Excel Macros : Developing Macros to Automate and Customize Excel

Roman, Steven

ISBN 10: 1565925874 / ISBN 13: 9781565925878

Published by O'Reilly Media, Incorporated, 1999

Used book that is in clean, average condition without any missing pages. Seller Inventory # 3743001-75

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.

Bibliographic Details

Title: Writing Excel Macros : Developing Macros to ...
Publisher: O'Reilly Media, Incorporated
Publication Date: 1999
Binding: Soft cover
Condition: Good
Edition: 1st Edition.