Is it possible to have VB code change when the file name changes?

[EdwinK]

I'm new to writting VBA code and what I've done so far works great except that when I change the name of the workbook and run the process, then a debug message occurs because the original name in the code didn't change when the workbook name changed. Is there a way to link the original workbook name, referenced in the code, to change when the workbook's name is changed? I really would appreciate some help on this.

 

[BAlGaInTl]

What code is giving the error?

I would just remove the reference to the name of the workbook. Is there a reason that you have to use it?

 

[VoG]

Hello and welcome to MrExcel.

Why not use ThisWorkbook to refer to the workbook that the code resides in.

 

[EdwinK]

Thank you VoG!!!! That worked beautifully.