You can always refer to the workbook containing the code with ThisWorkbook.
From that, you can get the name of the file, if needed, with

ThisWorkbook.Name
' or
ThisWorkbook.FullName


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"chilidog1000" wrote in message
...
I have a file that has code in it that references the file
name. Problem is when an end user gets the file they save
it as another name and subsequently get a run-time error.
Is there a way to change the VB references in the code to
point to the new file name? Muchos Gracis if you can help,
heck just thanks for reading!