My code works fine until it hits the command ActiveWorkbook.Save. That's
when I get teh error:

Run-time error '1004': Methond 'Save' of object '_Workbook' failed

This code was working fine, but now all of a suddent doesn't work fine in
Excel 2007.

Any suggestions? thanks very much.