I have a great macro that puts a worksheet from an open workbook, does
some editing and saves with a specific file name.

And, I found this code he

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Sheets("yourworksheet").Range("desiredrange") = Now
End Sub

to change a cell value from NOW() to the date it was saved.

Now, the problem.

The above code belongs in the ThisWorkbook part of the book's code, and
I don't know where to put that in the macro that creates the workbook
to put it in that part of the new workbook.

Thanks to all.