0

Is there a native function for this within Access? Or would I have to do this with a batch script somehow?

Moreover, could I rename the files in a directory based on fields in an Access table?

2

See Dir function in VBA help to show you how to loop through a folder looking for files. Note that you must be in the VBA editor to search VBA help.

See the Name statement which "Renames a disk file, directory, or folder."

0

Is there a native function for this within Access? Or would I have to do this with a batch script somehow?

If you add the Microsoft Scripting Runtime as a reference you can use FileSystemObject from VBA. See here for some good examples.

Moreover, could I rename the files in a directory based on fields in an Access table?

You can do this with VBA.

2
  • Is there some reason you go for an outside library instead of recommending the built-in Dir() function? – David W. Fenton Jun 12 '11 at 19:52
  • @David W. Fenton - I thought that to rename files you needed FileSystemObject but as Tony points out you can use Name. So all the functionality is built into VBA. – ta.speot.is Jun 13 '11 at 0:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.