=====
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
=========

(E-Mail Removed) (Jeff) wrote in
news:(E-Mail Removed):

>
> 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