Worksheet copy issue
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 |
Worksheet copy issue
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 |
Worksheet copy issue
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 |
All times are GMT +1. The time now is 01:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com