ASP.NET, SQL Server, WPF, C#, VB.NET

We have a C# application that is using the Excel object model via  
  
Interop.  
  
The code below works fine for an existing workbook, ie one that you  
  
have opened up (or saved), but if you open up Excel, click the New  
  
button, enter some data and then run the program below, an Exception is  
  
thrown:  
  
Exception for HRESULT: 0x800A03EC on the call to SaveCopyAs  
  
Is there a workaround? I have tried using the SaveAs method but to no  
  
avail.  
  
object missing =3D System.Reflection.Missing.Valu=ADe;  
  
object o =3D  
  
System.Runtime.InteropServices=AD.Marshal.GetActiveObject("Exce=ADl.Applica=  
  
tion");  
  
Excel._Application excelApp =3D o as Excel._Application;  
  
// connect to current Excel workBook  
  
Excel.Workbook workBook =3D excelApp.ActiveWorkbook;  
  
if (workBook =3D=3D null)  
  
{  
  
throw new ApplicationException("No workbook is currently  
  
defined");  
  
}  
  
string fileName  =3D "temp.xls";  
  
workBook.SaveCopyAs(fileName);  
  
workBook.Close  (missing  
  
,missing=20  
  
,missing);

PromisedOyster wrote:  
  
Hi,  
  
the reason behind that is that the input in the cell is not finalized.  
  
Just finish by using Enter and it should work.  
  
Regards  
  
Dirk

Thanks Dirk  
  
How can I finalise input in the cell programmatically.  
  
I have tried calling excelApp.SendKeys("~",object(false)) but to no  
  
avail.

PromisedOyster wrote:  
  
If there is more than 1 sheet in the workbook then  
  
// don't activate the active sheet as this does not help  
  
Excel.Worksheet workSh=workBook.Sheets.get_Item(2) as Excel.Worksheet;  
  
workSh.Activate();  
  
//  instead of SaveCopyAs you may try the following  
  
//workBook.Close((object)true,(string)fileName,(object)false);  
  
workBook.SaveCopyAs(fileName);  
  
//I would use false instead of missing  
  
workBook.Close  ((object) false	,missing,missing);  
  
If there is only one sheet in the workbook I only see the possibility to  
  
inform the user to finalize the input. You can not even run a macro  
  
inside Excel in this state.  
  
Sorry  
  
Dirk

PromisedOyster wrote:  
  
Another option could be to Activate Excels main window  
  
see http://www.codeproject.com/vb/net/ActivateSingleAppInstance.asp  
  
and then use System.Windows.Forms.SendKeys.Send  
  
to send either an Enter or an Escape  
  
Dirk