Thread: Constanty changing Workbook name( -2 business days)

If your code opens the other workbook, then just store the current workbook:

Dim wbkActive as workbook
Dim wbkNew as workbook
set wbkActive = activeworkbook
set wbkNew = workbooks.open("path")
wbkactive.activate

Note though that it is very rarely necessary to activate anything in code to work with it.

Path refers to the other workbook you are opening.