Replies

Thank you, Hans. Works great.

Thank you, Andrew. Excellent solution.

Hans,

Thank you the quick response and for the solution.

I am having difficulty getting it to run. Each time I enter a directory name, the code finds the first file, and an error message pops up saying:

Run time error ‘5174’
This file could not be found.
Try one or more of the following:
Check the spelling of the name of the document.
Try a different file name.
(AUG97.DOC)

The file name in () is always the first filename in the directory. I have tried a small directory with only 2 files, 1 file, etc., and the same error message appears.

What am I doing wrong?

Don