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

Hi Tommy
Go to Edit Links and link the book to itself.

Thanks
Barb

"TommySzalapski" wrote:


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

Thanks,
Tommy


--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=389934

No, I need to do it from within the macr

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