Is there a User Defined Function or something Similar that can be used to return the most recent file in a directory.

i.e.

=RECENTFILE("C:\mydocuments\andi\") would return the most recent file in C:\mydocuments\andi\

Any help would be gratefully received.

Thanks

Andi