I am currently running a macro to design my documents but my code is written to overwrite the existing file and save it in the same folder without any confirmation. I have 30 such unformatted files in the folder. But now I want to create a subfolder inside the parent folder to store all the formatted sheets and not overwrite them.

For e.g. if the location is "C:\Temp\File1. xls", then the code should automatically detect the...