Leonardo1234
Member
Looking for help
I am looking for a macro that will first check that all excel files are there or not & if all files are there then copy all the excel file & create a new folder & name that folder abc & paste all the excel files in it & delete that abc folder (Note there may be 3 or 4 or more excel files, & it has to look for all files & plz hardcode the path of the excel file in the macro so that i can change it as per my needs)
Plz note when we are deleting abc folder then that folder should go to recycle bin so that if i need that folder containing all that files then i can take it from recycle bin
I am looking for a macro that will first check that all excel files are there or not & if all files are there then copy all the excel file & create a new folder & name that folder abc & paste all the excel files in it & delete that abc folder (Note there may be 3 or 4 or more excel files, & it has to look for all files & plz hardcode the path of the excel file in the macro so that i can change it as per my needs)
Plz note when we are deleting abc folder then that folder should go to recycle bin so that if i need that folder containing all that files then i can take it from recycle bin