troubleshooting Question

How to select files in a folder (to get data from), selecting the most updated version based on name of file

Avatar of Emily Barnes
Emily Barnes asked on
VBAMicrosoft Excel
6 Comments1 Solution80 ViewsLast Modified:
I have a code to extract certain data from files in a folder but I would like to select the updated versions of these files (there are ten in total, with newer versions added frequently). The newer versions have higher numbers in the name so for example, the name of one file could be T1_D002 and then T1_D003 would be the new version of the TP1 files in the folder and this would be the case all the way to TP10. I already have a loop going through the folder to select certain files, but it will give all of the versions of the T1-T10's. The T and D parts are not the only characters in the file name. Any help would be wonderful.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 6 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 1 Answer and 6 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