Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: Running a macro when the workbook name changes

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Running a macro when the workbook name changes
I have a macro that reads Workbook 1 and puts certain info into Workbook 2. The problem is that Workbook 1 changes its name depending on the week we're in. Workbook 1's name right now is Consolidated 2012-08-18 to 2012-08-24 V2.xls but as you can tell, that's from August. Workbook 2's name is...