How to save work book while automation Excel

Question

this may be a silly question with a simple answer but I am automating ecxel from a windows form and in a click event I have:

Excel.Application objExcel = new Excel.Application();
Excel.Workbook objWorkBook = objExcel.Workbooks.Add(System.Reflection.Missing.Value);
Excel.Worksheet objSheet = (Excel.Worksheet)objWorkBook.Worksheets.get_Item(1);

//do stuff to sheet in workbook

but how do I save the work book to a specific location?

Sebastian · Answer

workBook.SaveAs(workbookFile Missing.Value Missing.Value Missing.Value Missing.Value Missing.Value XlSaveAsAccessMode.xlExclusive); the method has a lot of optional parameters. if you have optional parameter support(.NET 4) you can remove Missing.Value

alec · Answer

found this http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook.saveas(v=VS.100).aspx big help

alec · Answer

how do i set the file location (and i assume that the file name is inherited from the workbook name)