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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top