Checking all open excel file in current path and delete them from folder

hi there

Maybe this discussion can be helpful in you last step of deleting files

Kind Regards