VBA to return to a workbook whose name has been changed

[salam3623]

Hi,
Is there a way to write VBA in excel 2010 to cycle back to an open workbook (A) whose name has been changed? When this workbook (A), whose name changes each time it's released to user, runs through and a series of Macros, it leads them down a path to a newly created workbook(B). I need the macros to continue on and cycle back to the orginal workbook(A), but it's reference back to workbook (A) must vary based on workbook (A)'s name. All VBA is housed within Workbook (A) and runs off this workbook- the originator has to change name, though, each time it's released.

 

[ChrisM]

Any reference to "ThisWorkbook", as in "ThisWorkbook.Sheet1.Range("A1") = 5", will always refer to the workbook in which the macro code is running, so you could just preface all your macro code with that.

Or, you can create a workbook object and link it to book A:

Dim wrkbk as New Workbook

Set wrkbk = ActiveWorkbook 'assuming A is active

'now run code that creates and does stuff in B

'now it's time to return to A:
wrkbk.Sheet1.Range("A1") = "hello"

'clean up
Set wrkbk = Nothing

 

[salam3623]

Thank you so much!