Excel 2007 Compatability Issue

I have a marco I wrote in Excel 2003 that still works there, but no longer functions in 2007. This macro is embeded in a workbook and runs when the workbook opens. Essentially, it checks if a later version of the workbook is abailable and transfers the data from the "old" to the "new" workbook. There seem to be two hang-ups. Both the worksheet.unprotect and the workbook.save both throw a 1004 error when called in 2007. Anyone with similar experience? Any useful advice?

Thanks,

Dave

This is a snippet of the unprotect that does not work in 2007

Please Login or Register  to view this content.

This is the snippet of the save that does not work.

Please Login or Register  to view this content.