Fellow Forum Members,
I got a work related task that takes a lot of time and unfortunately no application exists that does this task out of the box. The task involves making anywhere between 60 to 120 copies from a single seed text file and then individually renaming each of the copied text files with sequential filenames (such as: Part0001.txt, Part0002.txt, Part0003.txt, etc...) It's very labor intensive!
I would much rather setup a 120 row sequential filename list inside Excel and then have a VBA script copy and paste the seed text file 120 times while also assigning sequential filenames it picks up from the filename list inside the control file. Is such a VBA script possible?
The Excel worksheet (control file) needs to have these columns:
Column A (CELL A1) = Path of Seed Text File
Column B (CELL B1) = Name of Seed File
Column C = List of sequential filenames
Column D (CELL D1) = Path of output folder where all the text file copies end up.
I have researched File Renamer applications, and none of them seem to have a feature that will let one duplicate a seed file many times and rename all of the copies with a custom sequential filename.
Any help will be greatly appreciated. Thanks.