I am using this code to open a workbook. It first checks to see if such a file exists. If the file exists, it will open it. If it doesn't it will advise the user.
ftr = format(usd, "mmm-dd (ddd)") & " schedule_5.xlsx"
If Dir("U:\PWS\Parks\Parks Operations\Sports\Sports17\DATA\" & ftr)...