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
Bookmarks