Folder with largest number

[SteveZmyname]

Hello
Is it possible for Excel to filter through a set of folders/directories and
determine which one has the largest number and then open it?

thanks for any insight

 

[Pete_UK]

Do you mean the largest number of files in the folder, or the file
with a (numeric) filename which is the largest value, or something
else?

Pete

 

[SteveZmyname]

Hello Pete
"the file with a (numeric) filename which is the largest value."
Yes, because the filenames are dates and I need to find the most recent to
work with.


thanks
Steve

 

[Pete_UK]

You will need a macro to do that. I suggest you post in the
programming group.

Pete