rename external file using DAO/ADO

  • Thread starter Thread starter ac
  • Start date Start date
A

ac

Hi all,

Is there way to rename my external files from ABC.20030501.01.TXT to
ABC2003050101.TXT so that i can import with transfertext command?
I have 100 files generated everyday and a loop procedure to process al files
will be helpful.

Thanks
ac.
 
The Name statement in VBA might work for you:

Name "OldName.txt" As "NewName.txt"

hth,
 
Yes Cheryl, thanks, that works with a while loop and concatenating the file
name.

cheers,
Pan
 
Back
Top