Accessing WorksheetFunction.XX from regular C# Forms application
 

I have been trying all day to use the WorksheetFunction.Trend and other
functions from a regular Windows.Forms application.
I have O2003 with .net support installed and VS2003
in references I have Microsoft.Office.Interop.Excel and its included
references.
I can create An Excel.Application obejct ( apparently ) but as soon as I try
to access a WorksheetFunction.XX on it I get an Exception :

The following exception occurred:
System.Runtime.InteropServices.COMException (0x80028018): Old format or
invalid type library.
at System.RuntimeType.ForwardCallToInvokeMember(Strin g memberName,
BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData&
msgData)
at Microsoft.Office.Interop.Excel.WorksheetFunction.A tanh(Double Arg1)

I would like to utilize the power of Excel in my application - so please
give me a pointer to a solution...

Regards
/Jes - gone matchracing for the evening :-)

That's a known bug with a matching KB article. Your thread locale must match
Excel's language.

Best regards,
Jens.

--
http://ManagedXLL.net/ | http://www.stochastix.de/
Replace MSDN with my first name when replying to my email address!

"Jes Ramsing" <Jes wrote in message
...
I have been trying all day to use the WorksheetFunction.Trend and other
functions from a regular Windows.Forms application.
I have O2003 with .net support installed and VS2003
in references I have Microsoft.Office.Interop.Excel and its included
references.
I can create An Excel.Application obejct ( apparently ) but as soon as I
try
to access a WorksheetFunction.XX on it I get an Exception :

The following exception occurred:
System.Runtime.InteropServices.COMException (0x80028018): Old format or
invalid type library.
at System.RuntimeType.ForwardCallToInvokeMember(Strin g memberName,
BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData&
msgData)
at Microsoft.Office.Interop.Excel.WorksheetFunction.A tanh(Double Arg1)

I would like to utilize the power of Excel in my application - so please
give me a pointer to a solution...

Regards
/Jes - gone matchracing for the evening :-)