Dates within file names
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?
Try this:
currentDate1 = Format(Date, "DD") & "-" & Format(Date, "MM") & "-" & Format(Date, "YY")
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Thanks Dave, I have already tried this, but had no success, it just returns:
Book1_
Then there is a problem with the code that you have not shown. Step through the code and see what filePath0 is right after you give it a value.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks