Creating clone worksheet with predetermined name without saving it

Hi All,

Does anyone know how to create clone of existing workbook with multiple sheets, without saving it? I need to make exact copy of the original workbook (all sheets, formulas and macros), after which will be followed with VBA which will rearrange with the data and sheets in the new, cloned workbook.

I also need to be able to rename the new workbook based on predetermine criteria (without saving it).
e.g.: "Clone workbook 2017.10.20 10:10:06" , where "Clone workbook" will be same text for each new workbook, and "2017.10.20 10:10:06" is the date and time where the clone workbook was crated.

Thank you in advance for your help.

Igor

hi kev_

Thank you for your input. I was just wondering if it is possible to do it.

At the end I've took different (simpler) approach. In same workbook I've created sheet with the final template (which is hidden). When i run the macro, it transfer the data to the final template, and hides all other sheets. With this, there is no need for some extra crazy complicated macros.

cheers
igor