Excel spreadsheet with macros to bulk/batch rename, copy, and move, files in Windows Explorer

Michael Dew
Michael Dew
34.8 هزار بار بازدید - 3 سال پیش - Spreadsheet can be downloaded through
Spreadsheet can be downloaded through link at https://www.legaltree.ca/node/2247

Spreadsheet contains macros which allow bulk renaming, copying, and moving of  files or folders in Windows Explorer. The following tabs in the spreadsheet offer the following functionality:

0:53 Rename files in place
Tool to rename files in their existing locations. The new name data can be created in Excel, typically using the original file names as starting data and then manipulating the data as needed e.g. using “find and replace”, or functions such as LEFT, RIGHT, LEN, VLOOKUP, etc.

4:39 Create subfolders
Tool to create empty subfolders (up to three levels) in the specified parent folder. Useful, for example, to create library of year and month folders for photographs.

7:43 Rename paths ("Move")
Tool to rename any part of the path e.g. just the file name, just the folder path, or both.

11:43 Copy to folders (& can rename)
Tool to put copies of listed files into specified target folders. The target folders do not need to already exist, but will be made by the macro as needed.

Helper sheet (Build file names) (used as part of "Copy to folders" demonstration):
Helper sheet to assist with building useful file names from pre-existing data. File metadata e.g. date modified, or photo date last taken, can be extracted from files using the FileList Software described in the previous video at Export detailed metadata from Windows...
3 سال پیش در تاریخ 1399/11/04 منتشر شده است.
34,841 بـار بازدید شده
... بیشتر