Hi team,
I need the BOT to find in FY2020 folder to check if "TMU 0011 P06’20.XLSX’ exist or not. If it does not exist then BOT will copy the template savein any other drive to this folder and Rename it to be "TMU 0011 P06’20.XLSX’ .
Template file maybe like "TMU 0011 P03’20.XLSX’ .
BOT needs to check in FY2020 folder for the files on the basis of periods to be P03’20,P06’20,P09’20,P12’20… that if the files not present for any of these then BOT will copy the template from local path and paste it in the FY2020 folder and rename it to be:
"TMU 0011 P03’20.XLSX’
"TMU 0011 P06’20.XLSX’
"TMU 0011 P09’20.XLSX’
"TMU 0011 P12’20.XLSX’
@som17
Assign a variable to store an array of string (This is to get all excel file in a particular folder path)
E.g Out_AllExcelFile = Directory.GetFiles(“C:/Desktop/FY2020”,”*.xlsx”)
Do a for loop on Out_AllExcelFile
If item.ToString.Contains(“P03”) just create multiple if for / switch P03/P06/P09/P12
If it does not exists then use copy file function (You can rename it from here)