Combine Excel files.

[Gintaras]

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