Disabling the Function Wizard in Excel
Some functions in quantitative libraries take a long time to evaluate. If you then export this function to Excel and try to populate the arguments via the function wizard you will find that the wizard is totally unresponsive. This is because the function is reevaluated every time you enter an argument. You have to disable recalculation in the Excel function wizard, otherwise it is unuseable. To do this read this, which is implemented in xlw.
I had some linker errors, LNK2001, in Visual C++ 6.0 such as __imp__GetParent, __imp__GetClassName, and __imp__EnumWindows. This was resolved by including user32.lib in the libraries to link against.
Posted in Software |