Search and replace to change a file name in a folder

[Sandy]

We have changed the protocol for importing TXT files into our Access
database and I need to convert some files names so that they map properly to
our database table fields.

All files are .TXT files. and I need to so something similar to a search and
replace

FIND *25*.txt within in file name and
REPLACE WITH *~25*.txt

Thanks for your help

 

[Karl E. Peterson]

We have changed the protocol for importing TXT files into our Access
database and I need to convert some files names so that they map
properly to our database table fields.

All files are .TXT files. and I need to so something similar to a
search and replace

FIND *25*.txt within in file name and
REPLACE WITH *~25*.txt

Build an array of files using the Dir function in a loop, then process each
one with the Replace function and Name method?

 

[Karl E. Peterson]

Build an array of files using the Dir function in a loop, then
process each one with the Replace function and Name method?

The implied "in other words" being, "what part are you having trouble with?"