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 <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> 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 <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> 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