Hi all and thanks in advance for any help.

I have excel workbooks that are produced on a daily bases by another
program. The data layout is the same for each day produced except for
the file name. What im having to do now is rename the file every day
and then run my other code to clean it up and import the data into my
new workbook.
The code that i use works great but would like to be able to fix it so
it doesn't matter what the file name is, so that others won't have to
remember to change the name before they run the cleanup code. Any
ideas.
Thanks, Pat


--
jenkinspat