XL97: Third-Party Utilities for Excel 97

ID: Q252910

The information in this article applies to:

Microsoft Excel 97 for Windows

SUMMARY

This article describes several third-party utilities that you can obtain from the Microsoft Download Center:

Visual Basic for Applications Code Cleaner for Microsoft Excel 97
Visual Basic for Applications Code Documentor for Microsoft Excel 97
XY (Scatter) Chart Labeler
Visual Basic for Applications Content Positioner for Microsoft Excel

NOTE: Microsoft Product Support Services does not support the following utilities. The third-party products discussed here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability. These utilities are provided as is. Microsoft does not accept responsibility for loss of data or files. Please carefully following the downloading instructions and the Readme file that is attached to each utility.

MORE INFORMATION

Visual Basic for Applications Code Cleaner for Microsoft Excel 97

During the process of creating Visual Basic for Applications programs, you may accumulate useless macros in your files. If these files aren't cleaned periodically, you may experience problems caused by this extra baggage. Cleaning a project involves saving all of it's modules as text files, deleting the modules, adding new ones to replace them, and then reimporting the code from the text files.

Developed and Submitted by Rob Bovey, The Baarns Consulting Consulting Group

The following file is available for download from the Microsoft Download Center. Click the file name below to download the file:

Clean97.exe

For more information about how to download files from the Microsoft Download Center, please visit the Download Center at the following Web address

http://www.microsoft.com/downloads/search.asp

and then click How to use the Microsoft Download Center.

Visual Basic for Applications Code Documentor for Microsoft Excel 97

This program automatically documents the "vital statistics" of a Visual Basic for Applications project. Statistics include a full module, a procedure listing for the project, and a Summary Info page. The Summary Info page details the sheet count and breakdown, the number of Subs, Functions, and DLL declarations, and the number of lines of code for the entire project and for the module. It also includes the module file size.

Developed and Submitted by Rob Bovey, The Baarns Consulting Group

The following file is available for download from the Microsoft Download Center. Click the file name below to download the file:

Codedoc.exe

For more information about how to download files from the Microsoft Download Center, please visit the Download Center at the following Web address

http://www.microsoft.com/downloads/search.asp

and then click How to use the Microsoft Download Center.

XY (Scatter) Chart Labeler

A very commonly requested Microsoft Excel feature is the ability to add labels to xy chart data points. The XY Chart Labeler now provides this feature for Microsoft Excel users. After the data labels are applied using the Add Labels utility, the Move Labels utility can be used to move the labels in any direction in one-point increments. The Manual Labeler allows you to apply labels to individual data points within a chart.

Developed and Submitted by Rob Bovey, The Baarns Consulting Group

The following file is available for download from the Microsoft Download Center. Click the file name below to download the file:

XYscatter.exe

For more information about how to download files from the Microsoft Download Center, please visit the Download Center at the following Web address

http://www.microsoft.com/downloads/search.asp

and then click How to use the Microsoft Download Center.

Visual Basic for Applications Content Positioner for Microsoft Excel

The Control Positioner allows you to automatically size and position controls on worksheets, dialog sheets or charts. The Control Positioner is not necessarily limited to controls; it operates on any drawing object that uses Top, Left, Width, or Height properties. The program also includes a nudger utility that allows you to move or size single controls or groups of controls in increments of one point.

Developed and Submitted by Rob Bovey, The Baarns Consulting Group

The following file is available for download from the Microsoft Download Center. Click the file name below to download the file:

Control.exe

For more information about how to download files from the Microsoft Download Center, please visit the Download Center at the following Web address

http://www.microsoft.com/downloads/search.asp

and then click How to use the Microsoft Download Center.

Additional query words:

Keywords : kbfile kbdta
Version : :
Platform :
Issue type : kbhowto