XL: Contents of the Samples.xls Workbook

Article translations Article translations
Article ID: 213528 - View products that this article applies to.
This article was previously published under Q213528
This article has been archived. It is offered "as is" and will no longer be updated.
For a Microsoft Excel 97 version of this article, see 162323.
Expand all | Collapse all

On This Page

Summary

Microsoft Excel ships with a file that contains samples for using Excel. This file is called Samples.xls, and it is located in the following folder:
Excel 2000
C:\Program Files\Microsoft Office\Office\Samples
Excel 2002
C:\Program Files\Microsoft Office\Office 10\Samples
This article contains a brief summary of the contents of the Samples.xls workbook.

More information

The Samples.xls workbook contains twelve worksheets: a table of contents worksheet, ten worksheets that are dedicated to a specific topic, and one worksheet that returns you back to the table of contents.

Contents

This worksheet contains introductory information, disclaimers, and links to the other worksheets.

Worksheet Functions

This worksheet contains sample formulas for completing common spreadsheet tasks, such as:
  • Suppressing the display of error values in formulas.
  • Indexing, matching, and looking up values by using the Lookup Wizard.
  • Calculating formulas based on conditions.

Conditional Formatting

This worksheet provides two examples that demonstrate how to change cell formatting depending on the current value of the cell.

Data Validation

This worksheet provides examples for setting up restrictions for values that can be entered into a cell.

Chart Labeling

This worksheet demonstrates how to add labels to points in an xy (scatter) chart programmatically. It provides sample data, a sample chart, and a link to the Visual Basic macros that create and remove the labels.

Repeating Tasks

This worksheet contains information about using different types of loops in Visual Basic macros: For Each...Next loops, For...Next loops, and Do... loops. The worksheet contains links to four Visual Basic modules that contain sample code.

Arrays

This worksheet contains information about using arrays in Visual Basic for Applications macros. The worksheet contains links to two Visual Basic modules that contain sample code.

API (Application Programming Interface) Examples

This worksheet contains nine examples for using API calls from within the programming environment in Excel.

Events

This worksheet contains information about having a certain event trigger a macro to perform a specific task. The events that are covered include BeforeDoubleClick, Change, and BeforeClose. Sample code is contained in this worksheet.

Automation

This worksheet contains information about automating tasks between Excel and other Office programs, such as Microsoft Word, Microsoft Access, Microsoft PowerPoint, and Microsoft Outlook. Links to sample code are included.

ADO-ActiveX Data Objects

This worksheet provides examples that illustrate common database tasks with code. It includes numerous links to sample Visual Basic macros.
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 213528 - Last Review: October 24, 2013 - Revision: 2.0
Applies to
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2002 Standard Edition
Keywords: 
kbnosurvey kbarchive kbhowto KB213528

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com