OK...I got it...I was a thread issue!Tx all

<t>I am trying to set a formula to a range using the IDISP_range.OlePropertySet (the same as Invoke with DISPATCH_PROPERTYPUT) but Excel crashes after the first use. In fact, Excel starts a kinf of endless looping and stop calculation at all.Here is some pieces of my code in C++ (Builder 6):********...

Have you try to use "ECHO(boolean)" function or "xlfEcho" (C enviroment) constant?

Yes - for "complex" and small toolsNo - for big tools

Try this:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Public Function ret_func(target As Range) As String ret_func = target.FormulaEnd Function~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Hi msr,If correlation matirx is not SPD, you will likely have negative eigenvalues. So. your PCA analisys is not valid.You could try to transform (proxy) your correlation matrix in a SPD one.

What about build in C++ enviroment with type checking and use a DLL in VB??

<t>Hi Leo,I’d like to add just some points:1) If you write your commercial application in C++, it will be very hard and almost impossible to “rebuild/decompile” the source code, especially with DLL or XLL applications. So, I agree with DavidJN, it’s the safest choice. 2) If your add-in can be cracke...

Hi Jogchum,To choose a decay factor you could use a process to minimize errors for future/predicted variance (one step ahead). That is equivalent to compute variance of predicted variance for each decay and take the one which minimizes it.HTH

<t>I’d like to add two things:1) Argentina is not a banana republic! They are not a tropical enough!2) Argentina already defaulted! I mean, twice!!So, let’s take another victim…for while, let’s keep BR (Banana Republic)…We have seen in the last emerging countries defaults (crisis or whatever…) a kin...

Have u try this code?~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Range("A1").SelectActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _ "http://www.wilmott.com.br/", TextToDisplay:="CLICK HERE"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Does anyone know the formula for standard error of intercept in multiple linear regression?Tx in advance.

<t>Hi Godfather,When you use Application. OnTime, the procedure you call at that time still remains even if you close your worksheet! It’s an application event and not a worksheet event!To avoid calling a macro after closing a worksheet, you have to cancel OnTime events!!You have to use something li...

<t>Hi Jack,A deterministic generator is one that you always have the same sequence. So, if you are testing some algorithm or solution you can run it again and have the same sequence to compare results. It's very useful to make simulations that need to be comproved latter by others then you!! Even be...

<t>Hi Sam,I thought u are doing directly from Excel and not from file streams (as u first said and I missed!!). All my comments are valid just for functionalities inside Excel (functions and commands).But Excel must work the same way. So, for the 2° column, you likely (now I'm not sure) have to read...