macro to open FILE

[drobinson782001]

i created a macro to look for a file based on on the date of the file and open it. I would like to modify it to pick up not only the current dated file but the most recent file, and if it doesn't see any files to be processed within that directory a message box should pop up stating "There are no files available for processing" then close the workbook

Please Login or Register  to view this content.