It sounds like your code creates a new workbook, but you want it to use a template instead. The way to do that is to open the template, instead of creating a new workbook, then immediately do a SaveAs with the desired name/path. Then everything else is the same. Then you Save again before closing.
However, I can't reconcile that with the code. If you are creating a new workbook, you're not doing it in the code below; see my notes in green. Do you have other code as well?
(I am still unclear on your overall problem because you said, "...sent to a worksheetD( on a new workbook B(this workbook has never been created)...". I don't understand how you can do anything in a workbook that has never been created.)
Bookmarks