Loading

How to save work book while automation Excel

alec

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?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sebastian15y ago
Accepted 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
alec15y ago
found this http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook.saveas(v=VS.100).aspx big help
alec15y ago
how do i set the file location (and i assume that the file name is inherited from the workbook name)