Save File to folder Where folder is referenced in cell

Hi,

I have an issue where I want to be able to save an excel file in to a specific folder with a macro.
This is what I currently have.

Please Login or Register  to view this content.

This macro works fine.
But what I also need is to be able to save the file into another sub folder which only gets created when the macro runs, this new folder is also named based on cell C6. This sub folder name needs to be unique and the same as the file name.

So really what I need the file path to look like is

Please Login or Register  to view this content.

Any ideas on how I can achieve this?

Please Login or Register  to view this content.

remove the red "

Please Login or Register  to view this content.