How do I DETERMINE and then RENAME a file (see example)?

[Jeff]

=====
ISSUE
=====
How do I rename a file whose original name changes?

=======
EXAMPLE
=======
Filename today : a1.xls
Filename tomorrow : a2.xls
Etc...

I ALWAYS WANT TO RENAME THIS FILE TO authorize.xls


Note: The "a" and ".xls" parts of the original filenames never
change (only the numeric part changes).



==========
BACKGROUND
==========
O/S = Win2000 Pro
Patches Installed

Software = Access 2000 (SP3)
Patches Installed



=========
Thanks!!!
THE END
=========

 

[Dev Ashish]

(e-mail address removed) (Jeff) wrote in

Note: The "a" and ".xls" parts of the original filenames never
change (only the numeric part changes).

Assuming you are looking for the most recent file if the process is run
daily, maybe you can loop through the folder looking for a*.xls files and
take the most recent? (FileDateTime function).

-- Dev