I am building a report creator which creates a new workbook for the dat
every fiscal week. The problem is, when I copy a worksheet to the ne
workbook from the template workbook the references still point to th
old workbook (i.e. =Data!B3 becomes =[Audits.xls]Data!B3) is there som
easy way to prevent this? I used the replace method to remove all th
["oldFileName"] instances but this is clumsy.

Thanks,
Tomm

--
TommySzalapsk
-----------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...fo&userid=2556
View this thread: http://www.excelforum.com/showthread.php?threadid=38993