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: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)
Please Login or Register to view this content.
Can anyone provide a suggestion?