SaveAs For C#

[jo15765]

In C# how would I add an Excel Workbook, and explicitly name the worksheet that is added to the workbook?

[jo15765]

Well I answered my own question after HOURS of googling --- thanks to all who viewed my beginner question

Here is the solution I used...

Excel.Application myApp;
Excel.Workbook myWorkBk;
object missingValue = System.Reflection.Missing.Value;
myApp = new Excel.Application;
myApp.Visible = true;
myWorkBk = myApp.WOrkbooks.Add(missingValue);
myWorkBk.SaveAs(@"C:\Try\TestData\Heythere.xls");
myWorkBK.Close();