Sorting files in a different folder via vba

[Enkay62]

Hi.
I have a workbook in a certain folder.
I would like to write a sub that allows user to sort (e.g. by name) all the files in another folder.
Is there a way to do this?
Thank you in advance.
Nick

 

[xlbo]

Don't think this can be done without an API call

Gotta ask why ????

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244