How do I copy a sheet in excel to another excel file with the format retained exactly from the source sheet to the destination sheet?

[Nero9 (Jacob)]

Copying sheets from one Excel to another

I have used invoke code activity to copy data from one excel to another excel with retaining excel data format Dim excel As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Excel.Workbook Dim nb As Microsoft.Office.Interop.Excel.Workbook Dim ws1 As Microsoft.Office.Interop.Excel.Worksheet Dim p_ws As Microsoft.Office.Interop.Excel.Worksheet Dim rng As Microsoft.Office.Interop.Excel.Range ‘capturing the range of sheet’ Dim p_rng As Microsoft.Office.Interop.Exce…