SteveGoodman
New Member
- Joined
- Sep 19, 2002
- Messages
- 41
I have been writing a C DLL (XLL) for Excel which extends the core forumals to link into one of our back end systems. We have got this working ok, but now we want to extend it.
The problem is we want to have a formula which takes 1 fixed parameter and then at least one pair of parameters, but possibly upto 36 pairs of parameters depending how the user does it. So it works similar to the sum formula where you can have =sum(B1+B2) or you could have =sum(B1+B2+B3+B4).
Do I have to code all 73 parameters into the code, or is there a way of passing a parameter array?
Also what would be nice is when you click on the FX button and select a forumla you get a dialog for entering the cell codes into, this comes as standard, but if we have 73 parameters this dialog is going to look real ugly, so does anyone know how the sum function works, as each time you populate the last parameter it adds another parameter onto the list?
Cheers
Steve.
The problem is we want to have a formula which takes 1 fixed parameter and then at least one pair of parameters, but possibly upto 36 pairs of parameters depending how the user does it. So it works similar to the sum formula where you can have =sum(B1+B2) or you could have =sum(B1+B2+B3+B4).
Do I have to code all 73 parameters into the code, or is there a way of passing a parameter array?
Also what would be nice is when you click on the FX button and select a forumla you get a dialog for entering the cell codes into, this comes as standard, but if we have 73 parameters this dialog is going to look real ugly, so does anyone know how the sum function works, as each time you populate the last parameter it adds another parameter onto the list?
Cheers
Steve.