Creating a folder inside a already existing folder

[humanerror]

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 file path and create a folder Formatted i.e. C:\Temp\Formatted (if it doesnt exist) and save all the files in that folder.

Please note that the code should take the file path automatically because the file path is different every-time for each file but the subfolder created name should be "Formatted".

Thanks in advance...
Anup

[smartchap]

Use fso for this. First store path of opened file in a variable, say OPath, then while saving (for surity) check if the file already exists there, Check if folder 'Formatted' exists in OPath or not, if not then create a new folder named 'Formatted' in the OPath otherwise save the file in the New Path as
NPath = OPath & "\Formatted"