Change macro on save

I have a template that auto opens a data workbook
when it is opened and then returns to the template.
See below.
The problem I have I after you save the file under a
different name the next time you open the file you get
a run time error.
Can we have a macro that rewrites on save to change the
name (job20011)to the current filename?
Or is there a better way to open a workbook without
making it activate?

Sub AUTO_OPEN()
Workbooks.Open Filename:="I:\DATA\MATERIALS.xls"
Windows("job20011").Activate