how can I usa VBA to move files listed in a table out of a folder

M

Merfi

I have created a database that sorts a list file names based on certain
criteria. I need to create a module in Access to look into a table that lists
files and then move those files out of their current directory (will have sub
folders) into another directory.

I have been able to move a single file with the MoveFile Method. I figure I
need to use For Each... Next to loop the module through the table field, but
I cannot find any examples or references on how to do this.

This module will also have to search through sub folders to locate these
files.

Any help is appreciated
 
Top