XL97: Contents of the Samples.xls Workbook (162323)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q162323 For a Microsoft Excel 2000 and later version of this article, see 213528.
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.
| Modification Type: | Minor | Last Reviewed: | 10/10/2006 |
|---|
| Keywords: | kbinfo KB162323 |
|---|
|