Search and replace to change a file name in a folder

S

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
 
K

Karl E. Peterson

Sandy said:
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
Click to expand...

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

Karl E. Peterson

Karl said:
Build an array of files using the Dir function in a loop, then
process each one with the Replace function and Name method?
Click to expand...

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