Microsoft Excel 2003 Programming inside Out

Overview

You’re a sophisticated user of Excel—a real pro with spreadsheets—so now dig into its powerful programming capabilities and really put your data to work! From writing code in Microsoft Visual Basic for Applications (VBA) to taking advantage of new XML data-sharing features, this book packs hundreds of timesaving programming solutions, troubleshooting tips, and handy workarounds all in concise, fast-answer format.

Discover the best and fastest ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (31) from $1.99   
  • New (6) from $4.48   
  • Used (25) from $1.99   
Close
Sort by
Page 1 of 1
Showing 1 – 4 of 6
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$4.48
Seller since 2007

Feedback rating:

(180)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand New. Sealed CD. No remainder mark. Ship daily. Pack carefully. E-mail when shipped. 62D

Ships from: Denver, CO

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$9.94
Seller since 2006

Feedback rating:

(58)

Condition: New
PAPERBACK New 0735619859.

Ships from: Foley, AL

Usually ships in 1-2 business days

  • Canadian
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$9.94
Seller since 2006

Feedback rating:

(58)

Condition: New
PAPERBACK New 0735619859 Brand new soft cover book. Soft cover books may show light shelf wear. Book may have remainder mark on it. Item ships within 24 hours with Free ... Tracking. Please ask about Expedited shipping. Read more Show Less

Ships from: Foley, AL

Usually ships in 1-2 business days

  • Canadian
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$45.00
Seller since 2014

Feedback rating:

(177)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing 1 – 4 of 6
Close
Sort by
Sending request ...

Overview

You’re a sophisticated user of Excel—a real pro with spreadsheets—so now dig into its powerful programming capabilities and really put your data to work! From writing code in Microsoft Visual Basic for Applications (VBA) to taking advantage of new XML data-sharing features, this book packs hundreds of timesaving programming solutions, troubleshooting tips, and handy workarounds all in concise, fast-answer format.

Discover the best and fastest ways to build custom business solutions with Excel—and challenge yourself to new levels of mastery!

  • From automating simple tasks to building custom solutions, write better code with VBA
  • Learn best practices for writing and debugging your own macros
  • Use VBA code to manage dates and times, reformat worksheets, and locate external files
  • Extend your Excel solutions by developing your own add-ins
  • Get powerful perspectives on data by programmatically manipulating PivotTable and PivotChart dynamic views
  • Create custom command bars, dialog boxes, and user forms
  • Employ ActiveX Data Objects (ADO) to access external databases
  • Exploit the new XML capabilities in Excel 2003

CD features:

  • Complete eBook in PDF format
  • Insider Extras—including all the authors’ sample files and code
  • Catalog of Excel resources with links to third-party tools and demos
  • Microsoft resources and demos, including Insider’s Guide to Microsoft Office OneNote 2003 eBook
  • FREE! Microsoft Computer Dictionary, Fifth Edition, eBook—10,000+ entries

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Read More Show Less

Product Details

  • ISBN-13: 9780735619852
  • Publisher: Microsoft Press
  • Publication date: 2/18/2004
  • Series: Microsoft Inside Out Series
  • Pages: 624
  • Product dimensions: 7.24 (w) x 9.44 (h) x 1.58 (d)

Meet the Author

Curtis Frye is the author of numerous books on Excel and other Office products, most recently the Excel 2007 Pocket Guide. He graduated from Syracuse in 1990 with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He moved to Portland, Oregon, in 1995 to launch his freelance writing career. When Curt's not writing, and often while he is writing, he is a keynote speaker, mentalist, and professional improvisational comedian.

Wayne S. Freeze is the Head of Software Development for Electrical Controls, Inc., where he builds software 3D graphics applications using Visual Basic, SQL Server and DirectX. He has written more than a dozen books over the years and has over seventy-five articles to his credit. Wayne has been using and writing about Access for nearly ten years, and has over 30 years of experience using all types of computers, from small, embedded microprocessor control systems to large-scale IBM mainframes. He also has a master's degree in management information systems as well as degrees in computer science and electrical engineering.

Felicia K. Buckingham, an expert on Excel and VBA programming, is the principal of FKB Consulting, based in Manitoba, Canada.

Read More Show Less

Table of Contents

Acknowledgments;
We’d Like to Hear from You;
About the CD;
What’s on the CD;
Using the CD;
System Requirements;
Support Information;
Conventions and Features Used in this Book;
Text Conventions;
Design Conventions;
Part 1: Preliminaries;
Chapter 1: What’s New in Excel 2003;
Using Improved Statistical Functions;
Creating Smart Documents;
Creating Document Workspaces;
Implementing Information Rights Management;
Comparing Workbooks Side By Side;
Getting Information with the Research Task Pane;
Using Extended XML Capabilities;
Chapter 2: Exploring Excel;
Workbooks;
Worksheets;
Cells and Ranges;
The Excel Interface;
Formulas;
Part 2: Visual Basic for Applications;
Chapter 3: Exploring Visual Basic for Applications;
An Overview of Object-Oriented Programming;
Working with Macros;
Chapter 4: VBA Programming Starter Kit;
Introducing the Visual Basic Editor;
Managing Code Windows;
Developing Projects with the Project Explorer;
Declaring Variables, Constants, and Data Types;
Assigning Values to Variables;
Working with Arrays;
Creating Dynamic Arrays;
Writing to the Screen and Accepting Input;
Defining Object Variables;
Creating Custom Data Types;
Controlling Program Flow;
Error Handling;
Chapter 5: Creating Sub and Function Procedures;
Defining Sub Procedures;
Defining Function Procedures;
Organizing for Success;
Part 3: The Excel Object Model;
Chapter 6: The Application Object;
Introducing the Application Object;
Chapter 7: Workbooks and Worksheets;
The Workbooks Collection;
The Sheets and Worksheets Collections;
Chapter 8: Ranges and Cells;
Basic Range Manipulations;
Referring to Ranges;
Manipulating Groups of Cells;
Using Named Ranges;
Getting Data Entry Right the First Time;
Part 4: Advanced VBA;
Chapter 9: Manipulating Data with VBA;
Manipulating Text;
Manipulating Numbers;
Manipulating Dates and Times;
Chapter 10: Formatting Excel Objects;
Using Excel Color Constants and the Color Palette;
Formatting Worksheet Elements;
Formatting Fonts;
Formatting Cells;
Formatting Borders;
Chapter 11: Creating Add-Ins and COM Add-Ins;
Introducing Add-Ins;
Using the Add-Ins dialog box;
Creating Excel Add-Ins;
Using the AddIns Collection;
Creating Automation and COM Add-Ins;
Building an Automation Add-In with Visual Basic 6;
Building a COM Add-In with Visual Basic .NET;
Chapter 12: Understanding and Using Events;
Enabling and Disabling Events;
Workbook Events;
Worksheet Events;
Application Events;
Chapter 13: Manipulating Files;
Locating External Files;
Writing to an External File;
Reading from an External File;
Searching a File for a Value;
Chapter 14: Developing Class Modules;
What Is an Object?;
What Is a Class?;
What Are Properties?;
What Are Methods?;
What Are Events?;
Introducing Class Modules;
Properties, Methods, and Events;
Building a Class;
Practical Class Design;
Part 5: Manipulating Excel Objects;
Chapter 15: Charts;
Introducing Charts;
Manipulating Charts;
Final Thoughts on Programming Charts;
Chapter 16: PivotTables and PivotCharts;
PivotTables and PivotCharts;
PivotTable Objects;
Programming PivotTables;
Manipulating PivotTables Programmatically;
Chapter 17: Command Bars;
Identifying Parts of the Menu System;
Command Bar Controls;
Chapter 18: Customizing Dialog Boxes;
Displaying Existing Dialog Boxes;
Modifying Existing Dialog Boxes;
Planning with Dialog Boxes;
Chapter 19: Creating User Forms;
Creating a UserForm;
UserForm Controls;
Chapter 20: Creating Advanced User Forms;
Capturing Information;
Building a Multi-Step Wizard;
Part 6: Excel and the Outside World: Collaborating Made Easy;
Chapter 21: Excel and Other Office Applications;
Starting Another Application;
Activating Another Application;
Binding;
Interacting with Other Office Applications;
Working with Multiple Applications to Get the Job Done;
Chapter 22: Excel and the Structured Query Language;
Comparing Spreadsheets and Databases;
Manipulating Databases with SQL;
The Select Statement;
The Insert Statement;
The Update Statement;
The Delete Statement;
Chapter 23: Introducing ADO;
The ADO Object Model;
The Connection Object;
The Command Object;
The Recordset Object;
Chapter 24: Excel Query Program;
Excel Query Program Overview;
Setting Up the Project;
Initializing the Program;
Ending the Program;
Connecting to a Database;
Editing a Query;
Executing a Database Query;
Using the Excel Query Program;
Chapter 25: Excel and the Web;
HTML;
Using the Internet as a Data Source;
Using the Internet to Publish Results;
Using Internet Solutions with Excel;
Chapter 26: Excel and the Extensible Markup Language (XML);
Introducing Data Lists;
Creating XML Schemas;
Creating XML Data Files;
Adding XML to a Workbook Manually;
Adding XML to a Worksheet Programmatically;
Appendix : About the Authors;

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 3 Customer Reviews
  • Posted October 17, 2009

    Very Good Reference Material for Intermediate Excel Users

    I purchased this book to complete a simple macro programming assignment I had. I am not a programmer by trade, but an IT Manager, but this simple assignment needed to be completed over a weekend.

    Together with my familiarity with excel and macro recording, this book allowed me to complete the assignment.

    Very infomative, well organized, easy to follow along.

    Made completing the assignment much easier and quicker.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted August 6, 2005

    Worth the money

    This is one of the few reference manuals that I've actually not regretted the cost after I really started to use it. Yes it's a bit low level for real programmers, but for those of us who wrote code years ago and need the training wheels for a couple of days, it's a winner.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted April 6, 2009

    No text was provided for this review.

Sort by: Showing all of 3 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)