We are currently working on migrating from Office 2003 to Office 2007.
In our Excel workbooks there are buttons that reference the Personal.xls file like Run("Personal.xls!DoSomething"). I can change the reference in the templates that these files were created from so that in the future it will refer to Personal.xlsb as Excel 2007 wants.
But how have (You) others handled when they have current files that refer to the old name. I really don't want to "fix" each of these manually as there are 100's created through out the year.
Ideas are well. Thanks.
In our Excel workbooks there are buttons that reference the Personal.xls file like Run("Personal.xls!DoSomething"). I can change the reference in the templates that these files were created from so that in the future it will refer to Personal.xlsb as Excel 2007 wants.
But how have (You) others handled when they have current files that refer to the old name. I really don't want to "fix" each of these manually as there are 100's created through out the year.
Ideas are well. Thanks.
