Reposting since msft failed to post previous answer, sorry if dupe

A new workbook is always the last one. You can find it with

Workbooks(workbooks.count).activate

to get the name

Workbooks.name = "whatever"

"Stephen" wrote:

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!