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

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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
=========
 
(e-mail address removed) (Jeff) wrote in
Note: The "a" and ".xls" parts of the original filenames never
change (only the numeric part changes).
Click to expand...

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