Excel Utilities
Downloadable Utilities
Baarns Publishing has developed a series of Excel Utilities to aid you in your development work on Excel. These can be downloaded free! Some of these utilities are now available for Excel 97!
As additional utilities become available we will have them here on our site. These are worth the download. They are a great resource for accomplishing advanced features in your workbooks.
Information provided in these documents is provided "as is" without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The user assumes the entire risk as to the accuracy and the use of this information.
Download XY Chart Labeler for Excel 95
(73K exe file - decompresses to an xls workbook)
Download XY Chart Labeler for
Excel 97 
(83K exe file - decompresses to an xls workbook)
A very commonly requested Excel feature (especially by former Lotus 123 users) is the ability to add labels to XY chart data points. The XY Chart Labeler now provides this feature for Excel users. Once 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 1 point increments. The Manual Labeler allows you to apply labels to individual data points within your chart.
Download Excel Control Positioner for Excel 95
(50K exe file - decompresses to an xls workbook)
The Control Positioner allows you to automatically size and position controls on worksheets, dialogsheets or charts. In fact, it is not necessarily limited to controls, but will operate on any drawing object that has 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 1 point.
Download Excel Dialog Converter Version 3.0 for Excel 97
(1.2M exe file - decompresses to an xls workbook)
One of the most important changes to Excel 97 VBA is the addition of a true Forms package. In order to take advantage of this powerful new feature you must convert all of your Excel 5/95 Dialog sheets into Excel 97 UserForms. The Excel 97 Dialog Converter takes most of the hassle out of this process by automatically converting the structure of your Excel 5/95 Dialog sheets and their controls into new Excel 97 UserForms with corresponding ActiveX controls.
Download VBA Code Cleaner for
Excel 95
(70K exe file - decompresses to an xls workbook)
Download VBA Code Cleaner
for Excel 97
(116K exe file - decompresses to an xls workbook)
During the process of creating VBA programs, a lot of "junk" builds up in your files. If these files aren't cleaned periodically you will start getting strange problems caused by this extra baggage. Cleaning a project involves saving all of it's VBComponents out to text files, deleting the components, and then importing the components back from the text files.
In addition to simply cleaning your project, the Code Cleaner provides an optional Strip Modules step that will remove all comments, blank lines and spaces from your code during the cleaning process. This allows you to achieve the minimum possible file size for your program.
Download VBA Project Documentor for Excel 95
(46K exe file - decompresses to an xls workbook)
Download VBA Project Documentor
for Excel 97
(78K exe file - decompresses to an xls workbook)
This program automatically documents the "vital statistics" of your VBA project. Statistics include a full module and procedure listing for the project, and a Summary Info page detailing sheet count and breakdown, number of Subs, Functions, DLL declarations and lines of code both for the entire project and by Module. Now includes module file size.
