I have a spreadsheet with macros in a previous version of Excel. It does not
work anymore. When I run the macro I get following error: Cannot run the
macro"append(1).xls'!main.' The macro may not be available in this workbook
or all macros may be disabled.

But when I disable the macro to merge several "csv" spreadsheets into one
sheet, I am getting a Microsoft Visual Basic Run-time error '1004': Method
'Range' of object '_Worksheet' failed.

Like I said, I was able to use this sheet before we HAD to convert to 2007,
and ever since then, it has not worked and it's the easiest way to merge
multiple sheets into one.

Any suggestions? Thank you for your help.