copy sheet from one workbook to other and retain the source sheet format

See more:

MS-Excel

Hi I am trying to copy a sheet from one workbook to another workbook.Below is the code i had used. With this code i am able to copy the whole sheet but the problem is it is not carrying the formatting in the source sheet

C# Code used:

objSourceWorkbook = ExcelApp.Workbooks.Open("Source Workbook Path", Type.Missing, true, Type.Missing,Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,Type.Missing);
objDestWorkbook = ExcelApp.Workbooks.Open("Dest Workbook Path", Type.Missing, true, Type.Missing,"Password to open the workbook", Type.Missing, Type.Missing, Type.Missing, Type.Missing,Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,Type.Missing);
objSheet = (Excel.Worksheet)objSourceWorkbook.Sheets["Sheet Name"];
ExcelApp.DisplayAlerts = false;
objSheet.Copy((Excel.Worksheet)objSourceWorkbook.Sheets[1], Type.Missing);
objDestWorkbook.Save();
ExcelApp.DisplayAlerts = true;

Please help me where am i doing wrong.

Thanks,
-Dileep