Moving Files from one folder to another with a twist

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would one compare the files in a folder with a record set in MS Access,
and move only those files with a matching entry in the record set to a new
folder? I've been playing with the code most of the day, and I have had no
luck, but I'm not a progammer, either. I've tried what I think is every
possible syntax for the MoveFile command and can't make it work. Your help
would be most appreciated. Thanks!
 
Mike said:
How would one compare the files in a folder with a record set in MS Access,
and move only those files with a matching entry in the record set to a new
folder? I've been playing with the code most of the day, and I have had no
luck, but I'm not a progammer, either. I've tried what I think is every
possible syntax for the MoveFile command and can't make it work. Your help
would be most appreciated. Thanks!

Not sure if this will help, but the VBA Name statement is rather
straightforward:


Name Statement


Renames a disk file, directory, or folder.

Syntax

Name oldpathname As newpathname
 

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

Back
Top