I found the problem...

I didn't have the close statement so I realy didn't see if there were any
exceptions thrown... And guess what - there were.

I got the "Old format or invalid type library. (Exception from HRESULT:
0x80028018 (TYPE_E_INVDATAREAD))" and had to set the culture to en-US.

For others needing the answer to this question, I changed the cultre info
like this:
System.Threading.Thread.CurrentThread.CurrentCultu re = new
System.Globalization.CultureInfo("en-US");

Now the current workbook closes - and not the excel application.


"neoret" wrote:

Yes, I've tried that. But then I quit every excel worksheet that is open...

My addin allows the user to archive the worksheet in an external archiving
system. The user may have many worksheets opened and I just want to close the
one he has just archived. Therefore I need to close the worksheet instance -
not the application.


"Arvi Laanemets" wrote:

Hi

Try this:
....
excelAppl.Quit


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"neoret" wrote in message
...
I have developed an addin using C#.

I need to close the application from my addin. I tired using the close
method like this:

private Microsoft.Office.Interop.Excel.Application excelAppl = null;
public Microsoft.Office.Interop.Excel.Workbook theActiveExcelWorkbook =
null;

excelAppl = (Microsoft.Office.Interop.Excel.Application)offApp lObject;
theActiveWorkbook = excelAppl.ActiveWorkbook;

this.theActiveWorkbook.Close(false, false, missing);

That does noe work. The code is called but nothing happens. No error
message
or nothing...

Do you have some advice for me on how to make this work.