PC Review Forums Newsgroups Microsoft Access Microsoft Access VBA Modules How do I DETERMINE and then RENAME a file (see example)?

Reply

How do I DETERMINE and then RENAME a file (see example)?
 
Thread Tools Rate Thread
Old 10-11-2003, 07:14 PM   #1
Jeff
Guest
 
Posts: n/a
Default How do I DETERMINE and then RENAME a file (see example)?


=====
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
=========
  Reply With Quote
Old 10-11-2003, 08:31 PM   #2
Dev Ashish
Guest
 
Posts: n/a
Default Re: How do I DETERMINE and then RENAME a file (see example)?
jhunter@huntercomputerinc.com (Jeff) wrote in
news:2b1df520.0311101014.2ebb41c3@posting.google.com:

>
> 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
  Reply With Quote
Reply

Archive


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off