Apparently, the DIR() function in kix isn't discriminating the file extensions properly. DirList uses the built-in DIR function to enumerate the files. DirPlus uses FSO, which should not exhibit this issue and has additional features. I still prefer DirPlus as it is faster when dealing with large directory structures.
There's an updated version of DirList (v1.3g) on my web site that I used to get around this issue. It will properly return "*.xls" files or "*.xlsx". To emulate the current behavior, specify "*.XLS*".
Our entire UDF library is published nightly to the Resources / Kixtart UDF Library section on our web site (URL in signature below).
Glenn
_________________________
Actually I
am a Rocket Scientist!
