XL97: Third-Party Utilities for Excel 97

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.

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:
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

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:
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

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:
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

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:
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.