Create Excel Reports the VBScript Way, Part 3

When you use VBScript scripts to create Microsoft Excel reports, you open up a tremendous amount of flexibility in Excel. This article series walks you through the practical code examples in the ExcelerateYourVBScripts.hta file, which you can download in its entirety with the .zip file associated with this article. In Parts 1 and 2 of the series, I covered fundamental routines that VBScript and Excel can perform, showed you how to reuse segments of code that perform common functions, and delved into two of the HTA's subroutines: XLCharts and XLHyperlinks. Now, I'd like to focus on the next routines in the ExcelerateYourVBScripts HTA, which let you concatenate items, find duplicates, and filter results in a spreadsheet.

This article covers not only concatenation, but also several commonly used Excel features, including conditional formatting, inserting columns, pasting formats, the CountIF function, and relative cell referencing. And although the focus of the example code is to find duplicates, I also discuss a number of fundamentals that you'll see repeatedly throughout this series—and that you're likely to use in many of your own Excel VBScript scripts. . . .