Excel Xll C add-in xl_array FP coerce
Mon, 15 Mar 2010 16:01:12 GMT
I was trying to obtain data from Excel via the FP array (xl_array) but was
completly unsuccesful.
I don't want to register the function just want to access it from VBA
Here is the declaration in VBA
Declare Sub arrayfn Lib "D:\Dev\XLAI\Debug\XLAI.dll" (ByRef v() As Double)
Here is the code of the VBA function ...
|
XLL: Optional parameters in Paste Function dialogue
Wed, 3 Mar 2010 06:21:02 -0800
I am developing an XLL that provides a number of functions some of which have
optional parameters. I am happy implementing this in code by detecting
whether the XLOPER has type 'xltypeMissing'.
However, I want the parameter name to appear in the Paste Function dialogue
in normal rather than bold type so as ...
|
How to refer to cell value in xloper12?
Tue, 2 Mar 2010 10:13:01 -0800
Assuming "amounts" is defined as an input reference to a range of cells:
xloper12 *amounts
How do you reference the individual values contained in the amounts range?
I tried using:
for(DWORD i = 0; i < result_size; i++)
{
n = amounts[i].val.num;
result.SetArrayElt(i, n);
}
Where "n" is a double ...
|
marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicote
Para Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 50924
Fri, 19 Feb 2010 19:08:03 -0800
Contato: marvendas@gmail.com
marvendas @ gmail.com
marvendas no gmail.com
Kit completo de solenoides para Volkswagem e Audi.
O kit contem:
5 solenoides
2 Epc ( solenoides de pressao )
1 Chicote
Serve para qualquer modelo VW ou Audi fabricados de 1995 ate hoje com o cambio automatico de 4 marchas ? 01M
Preço: ...
|
Solenóides ( solenoid ) + chicote Para Câmbio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 29909marvendas@gmail.com Kit completo de
Fri, 19 Feb 2010 17:55:29 -0800
Contato: marvendas@gmail.com
marvendas @ gmail.com
marvendas no gmail.com
Kit completo de solenóides para Volkswagem e Audi.
O kit contém:
5 solenóides
2 Epc ( solenoides de pressão )
1 Chicote
Serve para qualquer modelo VW ou Audi fabricados de 1995 até hoje com o cambio automático de 4 marchas ? 01M
Preço: ...
|
returning XLOPER from a function
Fri, 12 Feb 2010 09:06:01 -0800
Hi, I am new to XLL development.
I am trying to return XLOPER from the following function:
__declspec(dllexport) XLOPER* __stdcall Z_TEST2(double p_Years)
{
XLOPER arg;
arg.xltype = xltypeNum;
arg.val.num = p_Years + 1;
return &arg;
}
Function return type and arguments are descri ...
|
xll to return an array
Wed, 10 Feb 2010 10:05:01 -0800
I would post an example, but I'm not even sure where to begin...
I need to be able to create an xll function that takes ranges as arguments
(XLOPER12) and then returns an array value result (presumably also as an
XLOPER12).
Basically I have two issues:
1) I know how to declare and load a 2D array in C+ ...
|
|
|
getting a cell's comment in XLL
Tue, 9 Feb 2010 12:56:16 -0800
I am new to XLL development. I am studying Steve Dalton's book,
Financial Applications Using Excel Add-in Development in C/C++ (2nd edition).
I am trying to use Steve's function from page 298 in my code. The XLL gets
created but when I call the function from Excel 2007 it gives me #VALUE!
error.
Could som ...
|
Need list of VBA macros
Sun, 3 Jan 2010 03:24:55 -0800 (PST)
Hi,
In Excel 2003 I could use this call to retrieve all the sheet and
macros defined in a workbook.
Excel (xlfGetWorkbook, (LPXLOPER) &xMulti, 1, (LPXLOPER) TempInt (1));
This no longer works in Excel 2007, xlfGetWorkbook only returns the
list of sheets. I need to know if a certain VBA macro is defined in ...
|
Free software download 03027
20 Dec 2009 21:57:08 GMT
Free software download,The biggest software directory for freeware and shareware download at http://www.softwaremania.net
Here you can free download the latest sotfare on market, review them and rate. Read our news and express your opinion.
!NlE#>%tPavJp,U!seE@@@QEt ...
|
