Excel

Bulk File Copying, Renaming, Moving Template

Ease of Use

Easy

Version tested with

XL2000 

Submitted by:

XLGibbs

Description:

A fully functional template file which allows the user to provide various file names, source folders, destination folders, with numerous options for renaming files. Modifying the template is not recommended for beginners, although it is fully functional as provided. 

Discussion:

This template works as a catch-all for recurring file movement operations. In many offices, mainframe or server applications provide output files in either text files, comma delimited files, .rpt files, which subsequently are used by other people in the office. However, before the files can be used they need to be renamed and moved, or copied, or all of the above. This is for either the programmer providing the output files, or for the user receiving them. The use of this template will ease simple file move/copy/rename options, or will handle bulk operations. The layout of the file is simple, and is self explanatory with Screen Tips that are there to help, which can be turned off, as well as a default print sheet format for easy record keeping. Single files, entire folders, and files in many source directories going to many destination directories can all be handled with one execution. This will copy files of all types, but will not copy subfolders within a directory. 

Code:

instructions for use

			

How to use:

  1. Download the attached CopyFileTemplate_V1.6.xls compressed file
  2. Extract the file and save to a directory of your choice.
 

Test the code:

  1. Open the Template
  2. Identify a directory in the Source Directory column (You may double click to browse for a folder)
  3. Identify a destination directory (one will be created if it does not already exist, you may double click to browse for a folder)
  4. Identify the file you wish to copy (or leave blank to copy ALL Files)
  5. Optional drop down choices for "Move Only", and "Rename File" are available, with a custom rename option as well.
 

Sample File:

FileCopyTemplate_V1.6.zip 41.39KB 

Approved by mdmackillop


This entry has been viewed 408 times.

Please read our Legal Information and Privacy Policy
Copyright @2004 - 2020 VBA Express