Folder with largest number

S

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
 
P

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
 
S

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
 
P

Pete_UK

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

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top