Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to register a UDF (xlfRegister) that takes no param
Hi,
I'm registering a UDF function in Excel via Excel4(xlfRegister, ...). I want to register a simple fonction that just returns a string value (no need to pass parameters to the function) The problem is that the function paste dialog always ask for one arguments. I'm using "R#!" and I give an empty string for args names. Any help would be greatly appreciated! Thanks a lot, Nicolas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to register a UDF (xlfRegister) that takes no param
Hi Nicolas,
What is the code of your function and with what formula do you call it? -- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message oups.com... | Hi, | | I'm registering a UDF function in Excel via Excel4(xlfRegister, ...). | | I want to register a simple fonction that just returns a string value | (no need to pass parameters to the function) | | The problem is that the function paste dialog always ask for one | arguments. | | I'm using "R#!" and I give an empty string for args names. | | Any help would be greatly appreciated! | | Thanks a lot, | | Nicolas | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to register a UDF (xlfRegister) that takes no param
Hi,
The function prototype is : XLOPER* VssGetTriggerTime() { // ... (code that just puts a simple string in the returning XLOPER*) ... } I'm registering it with Excel4(xlfRegister, ... ) int err = Excel4(xlfRegister, 0, 10, &xlDllName, // Full drive, path and filename of the DLL &xlInternalName, // "VssGetTriggerTime" &xlFctPrototype, // "R#!" &xlInternalName, // "VssGetTriggerTime" &xlArgNames, // "" &xlFctType, // 1 (function) &xlFctCategory, // "" &xlEmpty, // "" (Not Used) &xlEmpty, // "" (no help topic) &xlFctDescription); // "Get a simple string" My function appear in the paste dialog. I can select it, but the function dialog ask me for an argument. If I write noting, the function is returning the test string. If I write something, the function is returning #VALUE. Why ...? I hope this will help you! Regards, Nicolas On May 23, 12:09 pm, "Niek Otten" wrote: Hi Nicolas, What is the code of your function and with what formula do you call it? -- Kind regards, Niek Otten Microsoft MVP - Excel wrote in ooglegroups.com... | Hi, | | I'm registering a UDF function in Excel via Excel4(xlfRegister, ...). | | I want to register a simple fonction that just returns a string value | (no need to pass parameters to the function) | | The problem is that the function paste dialog always ask for one | arguments. | | I'm using "R#!" and I give an empty string for args names. | | Any help would be greatly appreciated! | | Thanks a lot, | | Nicolas | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Output param from SQL | Excel Programming | |||
open a spreadsheet with param | Excel Discussion (Misc queries) | |||
build param string for WHERE IN (....) | Excel Programming | |||
Haeder/Footer param | Excel Programming | |||
CorruptLoad param of Workbooks.Open | Excel Programming |