Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I really hope I am right here. I am programming an excel client in c#, and I try to start excel with an empty workbook and then save it with a given filepath. Empty workbook seems ok: object missing = System.Reflection.Missing.Value; appExcel.Visible = true; wb = (Workbook)appExcel.Workbooks.Add(missing); However, when I try to Close(...) or SaveAs(...), excel allways comes up with the messagebox if I want to override the existing file. Example: wb.Close(true,"d:\\Excelsheet.xls",false); appExcel.Workbooks.Close(); appExcel.Quit(); My question: How can I prevent excel from displaying the messagebox, and save the file in any case ? Weired, in the case above, if I answer the messagebox with "no", I get an exception on the wb.Close() call. Thank you for any hints Fritz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving and Closing | Excel Worksheet Functions | |||
Saving and Closing | Excel Discussion (Misc queries) | |||
Prompting user to answer a question before saving and closing wkbo | Excel Programming | |||
closing & saving | Excel Worksheet Functions | |||
VBA - closing without saving changes | Excel Programming |