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
Bookmarks