Bulk file renaming

[trevolly]

Good afternoon all.

I'm wondering if anyone can recommend an app / program to help with multiple file renaming. I currently have a excel workbook for work and the master is called “Finalcopy.xlsm”. Each month I have to make a version of this for each day and night of the month - with the files needing to be renamed to the date and then day / night, for example “09-10-21 Day” or "09-10-21 Night". This involves making multiple copies of the master version and then renaming each file.

I'm wondering if anyone knows of a program that could be used to do this - but has to be able to rename the files in the date sequence , 01-10-21 Day, 02-10-21 Day etc.....

Thanks all
T

 

[rlv01]

I can't say I know of any app, but it were me, I would set up a worksheet and use Excel formulas to create the new file names based on the month I enter, and lines for a windows batch file to do the bulk copying. Then I would either paste the copy lines into a batch file, or else use VBA to write a macro to generate the needed batch file.

Book1
	A	B	C
1	First Day Of Month	10/1/2021
2	Days in Month	31
3	Souce File Path	C:\Users\AdminUser\Documents\Master Repository\
4	Souce File	Finalcopy.xlsm
5	Dest File Path	C:\Users\AdminUser\Documents\Month Repository\
6	Day	File Name	:: Batch File Lines
7	1	10-01-21 Day.xlsm	Copy "C:\Users\AdminUser\Documents\Master Repository\Finalcopy.xlsm" "C:\Users\AdminUser\Documents\Month Repository\10-01-21 Day.xlsm"
8	1	10-01-21 Night.xlsm	Copy "C:\Users\AdminUser\Documents\Master Repository\Finalcopy.xlsm" "C:\Users\AdminUser\Documents\Month Repository\10-01-21 Night.xlsm"
9	2	10-02-21 Day.xlsm	Copy "C:\Users\AdminUser\Documents\Master Repository\Finalcopy.xlsm" "C:\Users\AdminUser\Documents\Month Repository\10-02-21 Day.xlsm"
10	2	10-02-21 Night.xlsm	Copy "C:\Users\AdminUser\Documents\Master Repository\Finalcopy.xlsm" "C:\Users\AdminUser\Documents\Month Repository\10-02-21 Night.xlsm"
11	3	10-03-21 Day.xlsm	Copy "C:\Users\AdminUser\Documents\Master Repository\Finalcopy.xlsm" "C:\Users\AdminUser\Documents\Month Repository\10-03-21 Day.xlsm"
12	3	10-03-21 Night.xlsm	Copy "C:\Users\AdminUser\Documents\Master Repository\Finalcopy.xlsm" "C:\Users\AdminUser\Documents\Month Repository\10-03-21 Night.xlsm"
13	4	10-04-21 Day.xlsm	Copy "C:\Users\AdminUser\Documents\Master Repository\Finalcopy.xlsm" "C:\Users\AdminUser\Documents\Month Repository\10-04-21 Day.xlsm"
14	4	10-04-21 Night.xlsm	Copy "C:\Users\AdminUser\Documents\Master Repository\Finalcopy.xlsm" "C:\Users\AdminUser\Documents\Month Repository\10-04-21 Night.xlsm"
Sheet3

Cell Formulas
Range	Formula
B2	B2	=DAY(EOMONTH(B1,0))
B7,B13,B11,B9	B7	=RIGHT("00" & MONTH($B$1),2)&"-" & RIGHT("00" & $A7,2) & "-" &RIGHT(YEAR($B$1),2) & " Day.xlsm"
C7:C14	C7	="Copy " &"""" & $B$3 & $B$4 & """" & " " & """" & $B$5 & B7 & """"
B8,B14,B12,B10	B8	=RIGHT("00" & MONTH($B$1),2)&"-" & RIGHT("00" & $A8,2) & "-" &RIGHT(YEAR($B$1),2) & " Night.xlsm"

 

[trevolly]

Hey @rlv01 Thanks very much for the reply. I didn’t realise that you could use excel in that way. So using the info above I could rename the files with excel? Is it as simple as creating a sheet with that data in it? Do I then just run the sheet? Sorry but I’m quite inexperienced with excel. Thank you for replying.

 

[Fluff]

I tend to use Bulk Rename Utility for things like this Bulk Rename Utility - Free File Renaming Software

 

[trevolly]

I looked at Bulk Rename Utility - loads of options! Can it change file names for each file? I mean when bulk naming it could change the names in to 01-10-21, 02-10-21, 03-10-21 etc?

 

[Fluff]

Yes it can do that.

 

[trevolly]

Sounds good. Thanks I’ll have a play with the “hundreds“ of options!

 

[rlv01]

Hey @rlv01 Thanks very much for the reply. I didn’t realise that you could use excel in that way. So using the info above I could rename the files with excel? Is it as simple as creating a sheet with that data in it? Do I then just run the sheet? Sorry but I’m quite inexperienced with excel. Thank you for replying.

Yes, it does require some knowledge of Excel, so you might be better off with a utility like the one @Fluff suggested. Though it seems like the Bulk Rename Utility only solves half of the problem. You still need to copy/create the (max) 31 new files.