XL97: Contents of the Samples.xls Workbook

Last reviewed: February 27, 1998
Article ID: Q162323
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SUMMARY

One file that is included with Microsoft Excel 97 is a workbook that contains examples for using Microsoft Excel. This workbook, called Samples.xls, is located in the following folder:

   C:\Program Files\Microsoft Office\Office\Examples

This article contains a brief summary of the contents of the Samples.xls workbook.

MORE INFORMATION

The Samples.xls workbook contains eight worksheets: a table of contents worksheet, and seven worksheets that are dedicated to a specific topic. Each worksheet is described in this section.

Contents

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

Worksheet Functions

This worksheet contains information about suppressing error values in formulas and using the Lookup Wizard to find values in tables of information.

Arrays

This worksheet contains information about using arrays in Visual Basic for Applications macros. Two links to Visual Basic modules that contain sample code are also available.

Repeating Tasks

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

Chart Labels

This worksheet contains an example that shows you how to add labels to points in an xy (scatter) chart. Sample data, a sample chart, and a link to the Visual Basic macros that create and remove the labels are available on this worksheet.

Data Access

This worksheet contains detailed information about using Data Access Objects (DAO) to work with databases using Visual Basic macros. Numerous links to sample Visual Basic macros are available.

Office Automation

This worksheet contains information about controlling Word 97, Microsoft Access 97, PowerPoint 97, Outlook 97, and Office Binder 97 using a macro in Microsoft Excel 97. Links to sample code are available.

Events

This worksheet contains information about programming with events in Microsoft Excel 97. The events that are covered include BeforeDoubleClick, Change, and BeforeClose. Sample code is contained in this worksheet.


Additional reference words: 97 XL97
Keywords : xlvbahowto xlvbainfo xlformula xladdins xlchart xldao
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbinfo


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 27, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.