Mr Excel,
I have a little dilemma that you could perhaps help me with.
On my excel spreadsheet, I have reference to Destination Folder and the File Name I want.
I am wondering how I could make a VBA code that would automatically create a folder (referencing the File Name) at the location of the referenced Destination Folder.
Subsequently, afterwards, I am looking to save the excel file into the created folder with the same File Name reference.
I hope this makes sense and looking forward to any help!
Charles
I have a little dilemma that you could perhaps help me with.
On my excel spreadsheet, I have reference to Destination Folder and the File Name I want.
I am wondering how I could make a VBA code that would automatically create a folder (referencing the File Name) at the location of the referenced Destination Folder.
Subsequently, afterwards, I am looking to save the excel file into the created folder with the same File Name reference.
I hope this makes sense and looking forward to any help!
Charles