I assume you're using .NET for this?

Have you tried late binding to see if you get the same result? It would
look something like:#

Dim objExcel As Object
ObjExcel=CreateObject("Excel.Application")
....



--
Regards,


Bill Lunney
www.billlunney.com

"Luca Orlandi" wrote in message
...
I wish to programmaticaly set the calculation method to
manual; my code is something like:

Excel.Application eApp = new Excel.ApplicationClass();
eApp.Calculation =
Excel.XlCalculation.xlCalculationManual;

But an exception is thrown:

Exception: System.Runtime.InteropServices.COMException
Message: Exception from HRESULT: 0x800A03EC.
Source: Interop.Excel
at Excel.ApplicationClass.set_Calculation
(XlCalculation RHS)