LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jes Ramsing
 
Posts: n/a
Default 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 :-)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to convert julian date to regular calendar date Ron Excel Worksheet Functions 5 May 5th 05 11:05 PM
copy conditional format to regular format GDC Setting up and Configuration of Excel 3 May 4th 05 09:35 PM
Errors accessing shared speadsheet. Gary H Excel Discussion (Misc queries) 0 February 7th 05 05:11 PM
How do I convert a Julian date into a regular date? Jessica Excel Discussion (Misc queries) 4 December 2nd 04 02:54 AM
Office Apps accessing the Internet BigBirtha Excel Discussion (Misc queries) 1 December 1st 04 07:07 PM


All times are GMT +1. The time now is 11:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"