Working with External files

[Guest]

Using Access2003 I have a need to look into a directory, and one at a time,
rename and move each file there into another directory. The renaming and
moving I have an idea how to do, but how do I loop through the files in the
directory? There may be up to 10 files in the directory each with a
different name.

Thanks for any suggestions.

 

[Marshall Barton]

Using Access2003 I have a need to look into a directory, and one at a time,
rename and move each file there into another directory. The renaming and
moving I have an idea how to do, but how do I loop through the files in the
directory? There may be up to 10 files in the directory each with a
different name.

Check the Dir function and Name statement in VBA Help.

You code might be something like this air code:

oldname = Dir(path\*.*)
Do Until oldname = ""
Name "path\" & oldname As "newpath\newname"
Loop

 

[Guest]

Thanks Marsh,
With some small changes it works great.