Star Wars Sale
 
 

Special Offers see all

Enter to WIN!

Weekly drawing for $100 credit. Subscribe to PowellsBooks.news for a chance to win.
Privacy Policy

More at Powell's


Recently Viewed clear list


The Powell's Playlist | June 18, 2014

Daniel H. Wilson: IMG The Powell’s Playlist: Daniel H. Wilson



Like many writers, I'm constantly haunting coffee shops with a laptop out and my headphones on. I listen to a lot of music while I write, and songs... Continue »
  1. $18.87 Sale Hardcover add to wish list

    Robogenesis

    Daniel H. Wilson 9780385537094

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

PrefaceChapter 1: IntroductionPart 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
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
Edition Number:
2
Edition Description:
Trade paper
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.34
  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.