Copy Worksheet to new Excel Workbook

[EDN Admin]

Hi,
How do I copy a specific worksheet to a new Excel Workbook?
Below is my code but it crashes at the wb.SaveAs line...

<div style="color:Black;background-color:White; <pre>
Excel.Application app = <span style="color:Blue; new Microsoft.Office.Interop.Excel.Application();
Excel.Workbook wb = app.ActiveWorkbook;
Excel.Worksheet ws;

wb = app.Workbooks.Open(selectedFilePath, <span style="color:Blue; false, <span style="color:Blue; false, Type.Missing, Type.Missing, Type.Missing, <span style="color:Blue; false, Type.Missing, Type.Missing, <span style="color:Blue; true, Type.Missing, Type.Missing, <span style="color:Blue; false, Type.Missing, Type.Missing);

ws = (Excel.Worksheet)wb.Worksheets[1];
ws.Copy(Type.Missing, Type.Missing);

wb.SaveAs(<span style="color:#A31515; @"C:Test.xlsx", <span style="color:#A31515; ".xlsx", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

app.Quit();
[/code]
<br/>
Thanks!


View the full article