Renaming a text file

[Zahid]

How do I rename the linked text files?

 

[FBxiii]

do you want to rename the file or the linked table name?

 

[Douglas J. Steele]

Assuming you're setting FileName like:

FileName = "C:\MyFolder\Rea181_1.txt"

change it to

FileName = "C:\MyFolder\Read181" & Format(Date(), "ddmmyy") & "_1.txt"

In my opinion, though, you'd be better off using yyyymmdd so that the file
names will sort properly.