Windows Explorer rename part of file

Hello, I am new to working with the program.
I want to change the name of the existing Excel files in a folder and its subfolders in Windows explorer - they always have the month name as part of them and I want to change it to the next month. Files do not have to be opened
G:\FINANZ\RPA\September\1_Flowers\Flowers August.xls → change in Flowers September.xls
G:\FINANZ\RPA\September\2_Trees\Trees August.xls → change in Trees September

Example: Flowers August.xlsm should be changed to Flowers September.xlsm

  1. how do I tell that all subfolders must be traversed?
  2. how do I change part in name of excel file *August to *September

Thank you in advance Bettina

Hi @Bettina_Hornbe
Welcome to forum

Try this method please

Main.xaml (12.3 KB)

Regards,
Nived N

@Bettina_Hornbe
Screenshot

Assign actiivty

file_list=Directory.GetFiles("data","*"+Now.AddMonths(-1).ToString("MMMM")+".xlsx",SearchOption.AllDirectories)

I had used a data folder (you can change the folder name as according to urs)

In move file

From : item

To :  Directory.GetParent(item.ToString).ToString+"\"+Path.GetFileName(item.ToString).Replace(Now.AddMonths(-1).ToString("MMMM"),Now.ToString("MMMM"))

Regards,
Nived N

1 Like

@Bettina_Hornbe
if the issue is resolve kindly mark the answer as solution os that we can close the topic

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.