25 Books to Read Before You Die
 
 

Recently Viewed clear list


The Powell's Playlist | August 8, 2014

Peter Mendelsund: IMG The Powell's Playlist: Water Music by Peter Mendelsund



We "see" when we read, and we "see" when we listen. There are many ways in which music can create the cross-sensory experience of this seeing...... Continue »
  1. $11.87 Sale Trade Paper add to wish list

spacer
Qualifying orders ship free.
$39.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

More copies of this ISBN

Writing Excel Macros With Vba 2ND Edition

by

Writing Excel Macros With Vba 2ND Edition Cover

 

Synopses & Reviews

Publisher Comments:

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.

Synopsis:

Updated for Excel 2002, this text offers Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with an introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel.

Synopsis:

Offering a solid introduction to writing VBA macros and programs in Excel, this guide shows readers how to get more power out of Excel at the programming level.

Synopsis:

Writing Excel Macros with VBA, 2"nd" Edition offers a solid introduction to writing VBA macros and programs in Excel and shows readers how to get more power out of Excel at the programming level: focusing on programming languages, the Visual Basic Editor, handling code, and the Excel object model.

About the Author

Dr. Roman has authored 32 books, including a number of books on mathematics, such as Coding and Information Theory, Advanced Linear Algebra, and Field Theory, published by Springer-Verlag. He has also written Modules in Mathematics, a series of 15 small books designed for the general college-level liberal arts student. Besides his books for O'Reilly, Dr. Roman has written two other computer books, both published by Springer-Verlag.

Table of Contents

Preface Chapter 1: Introduction Part I: The VBA Environment Chapter 2: Preliminaries Chapter 3: The Visual Basic Editor, Part I Chapter 4: The Visual Basic Editor, Part II Part II: The VBA Programming Language Chapter 5: Variables, Data Types, and Constants Chapter 6: Functions and Subroutines Chapter 7: Built-in Functions and Statements Chapter 8: Control Statements Part III: Excel Applications and the Excel Object Model Chapter 9: Object Models Chapter 10: Excel Applications Chapter 11: Excel Events Chapter 12: Custom Menus and Toolbars Chapter 13: Built-In Dialog Boxes Chapter 14: Custom Dialog Boxes Chapter 15: The Excel Object Model Chapter 16: The Application Object Chapter 17: The Workbook Object Chapter 18: The Worksheet Object Chapter 19: The Range Object Chapter 20: Pivot Tables Chapter 21: The Chart Object Chapter 22: Smart Tags Part IV: Appendixes Appendix A: The Shape Object Appendix B: Getting the Installed Printers Appendix C: Command Bar Controls Appendix D: Face IDs Appendix E: Programming Excelfrom Another Application Appendix F: High-Level and Low-Level Languages Appendix G: New Objects in Excel XP Colophon

Product Details

ISBN:
9780596003593
Author:
Roman, Steven
Publisher:
O'Reilly Media
Author:
Steven Roman,, PhD
Subject:
Programming - General
Subject:
Spreadsheets - Excel
Subject:
Programming - Visual Basic - VBA (Visual Basic for Applicati
Subject:
Software Engineering - Programming and Languages
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Subject:
Macros;Microsoft excel;customize;excel;excel 2000;excel 2002;excel xp;object model;office xp;programming;vba;visual basic;visual basic for applications
Subject:
Programming Languages - Visual BASIC
Subject:
CourseSmart Subject Description
Edition Number:
2
Edition Description:
Second Edition
Publication Date:
20020731
Binding:
TRADE PAPER
Language:
English
Illustrations:
Y
Pages:
574
Dimensions:
9.19 x 7 x 1.06 in 1.82 lb

Other books you might like

  1. Learning Red Hat Linux, 2ND Edition Used Trade Paper $5.95
  2. Excel Advanced Report Development Used Trade Paper $11.95
  3. Excel 2003 Power Programming With Vba Used Trade Paper $24.00
  4. Higher-Order Perl
    New Trade Paper $110.88
  5. Mac OS X Power User's Guide... New Trade Paper $20.00
  6. Malware: Fighting Malicious Code... Used Trade Paper $17.50

Related Subjects

Computers and Internet » Computer Languages » Visual Basic
Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
History and Social Science » World History » General

Writing Excel Macros With Vba 2ND Edition New Trade Paper
0 stars - 0 reviews
$39.99 In Stock
Product details 574 pages O'Reilly & Associates - English 9780596003593 Reviews:
"Synopsis" by , Updated for Excel 2002, this text offers Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with an introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel.
"Synopsis" by ,
Offering a solid introduction to writing VBA macros and programs in Excel, this guide shows readers how to get more power out of Excel at the programming level.
"Synopsis" by , Writing Excel Macros with VBA, 2"nd" Edition offers a solid introduction to writing VBA macros and programs in Excel and shows readers how to get more power out of Excel at the programming level: focusing on programming languages, the Visual Basic Editor, handling code, and the Excel object model.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.