Hello.
In this
topic[
^] please look at code in first answer. It doesn't solves your problem, but using there, you can solve it by youreself.
I think, your code shoild be like that:
xlWorkbookFrom = xlApp.Workbooks.Open(fullFilenameFrom, 0, false, 5, "", "",
false, XlPlatform.xlWindows, "",
true, false, 0, true, false, false);
xlWorkbookTo = xlApp.Workbooks.Open(fullFilenameTo, 0, false, 5, "", "",
false, XlPlatform.xlWindows, "",
true, false, 0, true, false, false);
xlSheetsFrom = xlWorkbookFrom.Sheets as Sheets;
xlSheetsTo = xlWorkbookTo.Sheets as Sheets;
foreach(var sheet in xlSheetsFrom)
{
xlNewSheet = (Worksheet)xlSheetsTo.Add(sheet , Type.Missing, Type.Missing, Type.Missing);
xlNewSheet.Name = sheet.Name;
}
xlWorkbookTo .Save();
xlWorkbookTo .Close(Type.Missing,Type.Missing,Type.Missing);
...
But I really don't sure, that thiswill work, I never try.