Define what you mean by first file.

a file listing can be sorted by several attributes, so saying first file
isn't definitive. latest date/earliest date, alphabetically,
largest/smallest????

--
Regards,
Tom Ogilvy

"JT" wrote in message
...
I'm kinda of stuck and would appreciate your help. I have
a macro where the "open" dialog box is displayed.
Currently the user selects which file they want to
select. (Users are supposed to select the first one but
not everyone is following the "rules" .)

To resolve this issue, we would like the macro to select
the first file automatically. However, I'm having trouble
coming up with the code to do this. The name for the
first file is always something different.

Any suggestions would be greatly appreciated. Thanks....JT