Recent content by piofenton

I have a C# program which includes the use of some datagrids and launches some external programs through some VB DLLs also. When I deploy the .exe it works fine on most PCs, however on some I get an error when the datagrid is loaded suggesting that the minimum value of 'value' must be greater...

Hi all, I have generated some data in my application for which I am using Excel to determine a linear relationship. I want to display the resultant graph on my windows form. So far I have tried using the Office Web Chart component but with no success. Is there anyway I can use a picture pox to...

Hi all, I have generated some data in my application for which I am using Excel to determine a linear relationship. I want to display the resultant graph on my windows form. So far I have tried using the Office Web Chart component but with no success. Is there anyway I can use a picture pox to...

I sorted it out, though I have to be honest I'm not sure how I managed it. I think I may have had the Macros copied to one too many places or something! Thanks again!

I'll keep trying and I'll let you know if I figure out what I am missing. Thanks very much for your help!

An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in Filtration.exe Additional information: The macro 'HelloWorld2' cannot be found. Hmmm! Still not working. It must be something I am doing. I'm using MS Excel 2003 and maybe that's where the problem lies.

That makes sense. I am still having another problem though. for some inexplicable reason when I run the code on oApp.Run line I get a runtime error informing me that the HelloWorld Macro cannot be found. This is despite it very definately being coded in the relevant Excel file. Any ideas why...

Thanks EarthandFire, I will try this and let you know how it goes. Thanks for your help.

I am trying to call an Excel Macro from .Net. The macro is called DoKbTest and is stored in book1.xls However when I run the code I get the following error "An unhandled exception of type 'System.Reflection.TargetInvocationException' occurred in mscorlib.dll. Additional information: Exception...

I have lost some sleep and have balded slightly over this problem! My thanks! I love you people!

Ia ma trying to use a MS EXcel DataAnalysis tool through .Net as shown below. However I am running into a number of problems mainly though that the last line here expects 30 parameters, all bar one of which should be optional, and the compiler won't accept anything less. Plus these parameters...

PS forgive the type in the Thread Title

That worked! Thanks so much!

I'm trying to get Excel launched from inside a C-Sharp program. unfortunately I keep getting the following error when I try to debug. Why is it not accepting Excel as a legitimate class? The type or namespace name 'Excel' could not be found (are you missing a using directive or an assembly...

Thanks JurkMonkey!