Hi I have a workbook named "Master" that contains a macro. The macro creates a new workbook from this, names it and saves it (for example, the child workbook is named "Master_mm-dd-yy" using today's date.

In the macro I can activate the original sheet by adding the code
Code:
Windows("Master.xlsm").Activate
but i don't know how to activate the new workbook since I don't know what name to put in this line in the code (since the name will depend on the date on that day)

Can anyone provide a suggestion?

Thank you!