04-08-2020, 12:11 PM
|
|
Expert
|
|
Join Date: May 2013
Location: USA
Posts: 700
|
|
A VBA solution is certainly possible—and a lot more fun —but I'd need to know what variations you think the filenames might exhibit before I can come up with an algorithm. What else might the filename look like, and which part do you want to extract in each case?
And I see your point about the user being able to enter a table of possible filename types and associated formulae—more flexible that way. I'll try to take a look at that tonight (since my original program didn't work for you) and make a program that behaves correctly.
|