I am able to find a file with the name
Book1_ddmmyyyy.xls
using
currentDate1 = Format(Date, "DD") & Format(Date, "MM") & Format(Date, "YY")
filePath0 = "Book1_" & currentDate1 & ".xls"
However, I need to be able to open the following
Book1_dd-mmm-yyyy.xls
I have tried to adjust my currentDate1 formula, but can not get it right as it tells me
"the file "Book1_" does not exist"
Anyone able to assist?
Bookmarks