I have 5 excel files in a particular folder to prepare consolidated sheet using 5 of them.
–> The first thing that I have to do is: – check whether 5 files are available or not using the key word of the file.
–> if any of the file is missing in the folder, then get the file name which is missing and send an email.
–>if all the 5 files are available in the folder, then rename the files accordingly. I’m able to rename the files using foreach loop and if the file containes a keyword.
Can you please refer the below screenshots and update me how can i get the missing files.
Thanks in advance.
and then find the key word of the file and rename the files accordingly.