Daily Dose of Excel

Hi,

A while ago I requested beta testers for a new utility, now called “ExcelRefTool”.

Thanks to my beta testers, the tool is now mature enough to be exposed to the general public.

Have a look here, download the demo if you like and give it a spin.

And thanks again, to everyone who took the trouble of beta testing this tool for me!

Regards,

Jan Karel Pieterse
www.jkp-ads.com

Hi everyone,

I am busy building my very first COM addin for Excel and I’ve now come to the stage that I need some beta testers.

Who would be willing to run some tests on my new “Excel Formula Reference Auditing Utility” (see screenshot below)?

If interested, send me an email:
info@jkp-ads.com

What’s in it for you? a free copy of the tool once the beta is finished.

###EDIT Oct 29, 2007###
I’d like to thank everyone who has volunteered for beta testing. For now, I have sufficient people doing testing, so the subscription is closed.

Regards,

Jan Karel Pieterse
www.jkp-ads.com

Since we’re on the topic of Excel utilities lately, I figured I’d jump in with my announcement of a new major version of the Excel VBA Code Cleaner. Here’s a brief summary of what’s new:

• The code cleaner is now implemented as a COM add-in. This has significantly improved its speed and stability.
• I addressed the most commonly requested improvement by adding two new features: code module export-only and code module import-only. While not technically related to code cleaning, I’ve received numerous requests from users who want the code cleaner to assist them with Excel source code control.
• I addressed my second most common feature request by exposing virtually every function used within the code cleaner to COM automation. You can now use the code cleaner DLL to roll your own code cleaning and code management solutions.
• The code cleaner desperately needed a high-quality help file, and I finally wrote one for this version. The help file includes complete documentation of the COM interface, including examples.

Like previous versions, the code cleaner is free and source code is included. With this version, however, you’ll need a copy of VB6 to take advantage of the source code because that’s what I used to write it. The source code will be located in the installation folder in a file cryptically named VB6_SourceCode.zip.

You can download the new code cleaner from:

http://www.appspro.com/Utilities/CodeCleaner.htm

Please uninstall any previous versions of the code cleaner prior to installing this version. Comments and bug reports welcome.