XLStylesCleaner turned out to be very popular. I really appreciate all the positive comments from the application users in the previous post. The utility has been out for about a year and seems to work without any issues. I only had to help people out with installing .Net3.5 framework when they couldn’t run the application. There were a couple asks:
1. The top ask was for a bulk file processing utility. I went ahead and wrote a console application that can process multiple files: XLBulkCleaner. Just start the utility, copy your files onto a monitored share or just open and close each file on the share once, watch the progress in the console window and when it is done your files are clean. The cleaning algorithm is the same as in the XLStylesTool, so you have all the same options that you were able to set in the WinForms app.
2. The second ask was to see who keeps on corrupting files. I wrote another console utility MonitorFileAccess that can detect who opens what file and when for edit. Now you can catch people that keep on re-introducing bad styles and named ranges into your cleaned up files (apparently it is a common problem as well). Or if you ask someone to edit your Word document or PowerPoint presentation you can see when that someone actually got to your request and how long did he/she have the file open for.
Once again please leave me a comment if you use these utilities and let me know what you think of them. My family, friends and now user feedback is what inspires me to write these applications in my spare time and keep on helping resolve common problems that affect thousands of people.
UPDATE [8/25/11]: added one more version of XLBulkCleaner with subfolder support based on the user ask from an earlier post. Get XLBulkCleanerSF from the link above if you need to: a) process really large volumes of files (I increased buffer size in this version) and/or b) that are placed in multiple folders and you want to keep this folder structure intact.