Combine Excel files.

[martinisonline]

Yes

Maybe Excel does not like some characters in new name.

Try this macro. It renames the last sheet.
Macro Macro1526

Code:

Copy      Help

ExcelSheet esm.Init
Excel.Workbook wb=esm.ws.Parent
Excel.Worksheet wsLast=wb.Sheets.Item(wb.Sheets.Count) ;;get last sheet object
out wsLast.Name ;;show old name
wsLast.Name="test" ;;rename

This peace of code works like a charm!

Try to replace that line to

wb.ActiveSheet.Name=name

this change returns an RT error saying that "the name is invalid...". (In Pt language, so this message is get direct from excel)