Our org converted to XL2007 and we have a LOT of legacy programs out there
that use/populate/manipulate multiple files.

In the past, there was only one working file extension, XLS. Now, with our
legacy files, there could be three: XLS, XLSX, XLSM (I know there are several
other types, but these are the primary three that we would be using).

Now, since there are several different file extensions, many of our programs
will misfire when looking for target files. Anyone have any suggestions on
how to deal with this neatly in code? I'd hate to have to set up an
"If...Then..." everytime to try each file extension...any ideas?

Thanks in advance for your help.