Hi ,

I am trying to write a macro that goes into the same folder directory and
searches for the latest modified file and open that workbook... the Dir is
"H:\My WorkStation\PRCD" , and the filename is named after PRCD and the date
when the file is created....so each time a new worksheet will be created by
date created.e..g. in the folder, these are the worksheet found:

PRCD052207.xls 'this is the most newest file looking at the "date Modified:
PRCD041807.xls
and so on....

How can i write the macro to run this?