rename external file using DAO/ADO

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

Cheryl Fischer

The Name statement in VBA might work for you:

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

hth,
 
A

ac

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

cheers,
Pan
 
Top