I have an .xls file (compatibility mode) containing about 40 worksheets. My goal is to save each worksheet as a separate workbook. To do this, I turned to David Mcritchie's macro, found here: http://www.mvps.org/dmcritchie/excel/saveas.htm
I run this macro in Excel 2007. It works, but I get the...