Dynamic Workbook Name

Hi All,

Very basic user here. Quick question, I have some VBA code the currently select workbook xyz.xls, runs its course and everything is fine. My question is, I want to be as to take my overall xyz.xls workbook, save as abc.xls and when I reopen abc, have the macro update abc instead of xyz. So basically is there a way to tell the macro to select "current workbook" instead of the original xyz? Thanks for any suggestions.

If need be I'm happy to post the code I have so far.

Look at ThisWorkbook and ActiveWorkbook

ThisWorkbook worked great, thanks so much.