If by "macro" you mean a VBA function, that is the only way.
AFAIK, there are
no regular Excel worksheet functions that even read files names from a
directory, to say nothing of the the date & time modified. There is, of
course, an old XLM macro function that will retrieve the file names, but not
the times.
On Fri, 19 Nov 2004 06:25:32 -0600, andibevan
wrote:
Hi All,
Is there a formula which can be used to display the name of the most
recently editted file in a specific directory.
I have a macro which does this but need to try and find a formula to
use?
Any ideas?
Thanks
Andi