S
Stephen
Hi Folks,
I have a macro that opens a new workbook and copies info from its source to
the new workbook before renaming the new book with the appended date. My
problem is the new workbook is not alway Book1.
Anyone know a way to find the new workbook name and use that in my
Windows("New Workbook.xls").Activate statement?
TIA!
I have a macro that opens a new workbook and copies info from its source to
the new workbook before renaming the new book with the appended date. My
problem is the new workbook is not alway Book1.
Anyone know a way to find the new workbook name and use that in my
Windows("New Workbook.xls").Activate statement?
TIA!