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 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





Sub OpenUp()

Workbooks.Open FileName:="\\use.opp.net\MBA\SPRINT_Loads_Testing\mobile_sprint_general_" & Format(Date, "YYYYMMDD") & ".csv"



End Sub