troubleshooting Question

Need to copy multiple files by specific name nand modified date

Avatar of Stephen Roesner
Stephen RoesnerFlag for United States of America asked on
Microsoft Access
5 Comments2 Solutions19 ViewsLast Modified:
I have 5 file names that I need to copy from one folder to another each day using yesterdays date.
So for example I need to copy over on June 24th, file EFTO.RS5617.DTRRD.D*.* with the date modifed of June 23rd. their might be 1 or 2 or 3 files for that date.
I normally use this code but don't know how to incorporate also looking for the mod date:
   While strFilename >""
      filecopy strPath1 & strFilename, strPath2 & strFilename

Any help out there?


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros