Refer to Macro Workbook that name keeps changing

[mattress58]

The workbook I have a macro in may be saved under a new name. How can I reword this and just refer to this as this work book instead of by name. The current name is "Combined Flow.xlsm", so the macro works, but it wont work if its save as something else.

[Kaper]

For instance:
instead of:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

PS. As you see ThisWorkbook is not equivalent of activeworkbook - Thisworkbook it is the one, where macro resides.

Another possibility:

Please Login or Register  to view this content.

this will store reference to active (at this moment) workbook in a variable and when needed "reactivate" it.

[mattress58]

Awesome. Worked great. Thanks