Writing Excel Macros: Automating Excel to Work for You - Softcover

Steven Roman

  • 3.63 out of 5 stars
    68 ratings by Goodreads
 
9781565925878: Writing Excel Macros: Automating Excel to Work for You

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.

"synopsis" may belong to another edition of this title.

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.

"About this title" may belong to another edition of this title.