hi, i've a code which creates a new workbook each time when the code is run. the code is not so perfect and want to amend and add to it the following fucntionalities
Please Login or Register  to view this content.
i want the code to ceate a new workbook each time it is run and name it after cell A1 sheet1 after cerating a new folder, the folder will be named after cell A2 sheet1. if the folder already exixts then skip the create folder step and just create newworkbook into it and save.