This is the result of typical Govt busywork...

We have a product that inventories software - the report is incomprehensible, and hundreds of lines long. Manager wants a summary (in Excel). Assigns it to someone to manually review and summarize!

A Kix script with these UDFs and about 40 lines of code reads an ini file & parses the individual report files, summarizes them, and creates a multi-tabbed workbook with the detail. Now all we do is dump the unwieldly reports to .TXT files each month, run the script, and it generates the .XLS file in about 12 seconds. Of course, we turn it back to management in 4-5 days (and they're grateful for the fast turnaround!).

Glenn
_________________________
Actually I am a Rocket Scientist! \:D