Hello, you can do this using VB script, you can ge tthe date and time stamp
of the file, and check when the file was created.
Hope this is helpful
Anand.V.V.N
--
"Who will guard the guards?"


"Don Doan" wrote:

hi,
i have folder that contain one new file each day. It's a text format file.
The naming format is as follow:
The folder is located at C:\dividend. And if today's date is jan 1 2008 then
the file is dividend.yester.Jan012008.txt. So the next day, the new file
would be dividend.yester.Jan022008.txt. These file only created during
weekday.

I have to import the content of these text file into excel each day. Is it
possible to create a macro in excel that would automatically locate the most
recent file and import the content automatically??

Thanks.
Don