I create a new workbook each day (titled as PREV.DAY'SDATE) by copying the previous day's workbook and changing the file name. I recorded a macro in today's workbook, and everything about it will work except all the mentions of the filename. How can I change all mentions of "9Aug11.xls" to the...