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.

Is the file it is in saved as an .xlxm? I don't have xl2007 so I am
guessing, but I know that the file extensions are different and if
append(1).xls is the workbook with the macro, you probably need to save it as
..xlxm and change your call statement to reflect that.

"daydd" wrote:

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.