Save Workbook as New File Leaving New One Open

[adam2308]

I have this code in a module to save the workbook as a new file.

Please Login or Register  to view this content.

My problem with this is that it closes the new workbook. I want it save the template workbook as a new workbook but keep the new workbook open.

I guess it is only a small amendment but I'm not sure what to change/add?

[Domski]

Try:

Please Login or Register  to view this content.

Dom

[adam2308]

Thanks Domski