[users] Re: Help with writing macro

2011-09-21 Thread Johnny Rosenberg
2011/9/20 Grzesiek Sójka p...@sojka.co: Hi there. I need to write a macro accepting variable length parameter list. I was tryint to googl but no luck. So the question is how to write (preferably in OpenOffice Basic) macro accepting variable length parameter list. Thanks in advance for any

[users] Re: Help with writing macro

2011-09-21 Thread Grzesiek Sójka
On 09/21/11 17:08, Johnny Rosenberg wrote: Can you give an example? I'm not sure what you mean by ”accepting variable length parameter list”. I do need to get some kind of statistic-like data. So I can not make any assumptions on the number of the results specified. Lets say that my macro is

[users] Re: Help with writing macro

2011-09-21 Thread Johnny Rosenberg
2011/9/21 Grzesiek Sójka p...@sojka.co: On 09/21/11 17:08, Johnny Rosenberg wrote: Can you give an example? I'm not sure what you mean by ”accepting variable length parameter list”. I do need to get some kind of statistic-like data. So I can not make any assumptions on the number of the

[users] Re: Help with writing macro

2011-09-21 Thread Grzegorz Sójka
On 09/21/11 18:53, Johnny Rosenberg wrote: I haven't done this myself, but I would try to use ”Optional” and ”IsMissing”, something like this: Function MyFunction(A As Double, Optional B As Double, Optional C As Double) As Double ' Some code If IsMissing(B) Then ' Do

[users] Re: Help with writing macro

2011-09-21 Thread Dennis E. Hamilton
: [users] Re: Help with writing macro On 09/21/11 17:08, Johnny Rosenberg wrote: Can you give an example? I'm not sure what you mean by ”accepting variable length parameter list”. I do need to get some kind of statistic-like data. So I can not make any assumptions on the number of the results

[users] Re: Help with writing macro

2011-09-21 Thread Tom Keene
How about passing your data in an array. Then you only need one parameter. On Sep 21, 2011, at 12:53 PM, Grzegorz Sójka wrote: On 09/21/11 18:53, Johnny Rosenberg wrote: I haven't done this myself, but I would try to use ”Optional” and ”IsMissing”, something like this: Function

[users] Re: Help with writing macro

2011-09-21 Thread Grzesiek Sójka
On 09/21/11 23:12, Tom Keene wrote: How about passing your data in an array. Then you only need one parameter. Could you please be a little more specific?? I do not have to much experience in writing macros. -- - To unsubscribe

[users] Re: Help with writing macro

2011-09-21 Thread Andrew Douglas Pitonyak
On 09/20/2011 04:48 PM, Grzesiek Sójka wrote: I need to write a macro accepting variable length parameter list. I was tryint to googl but no luck. So the question is how to write (preferably in OpenOffice Basic) macro accepting variable length parameter list. I am not aware of any way to write

[users] Re: Help with writing macro

2011-09-20 Thread Anthony Chilco
Hi GS, Check this out: http://www.pitonyak.org/oo.php tc From: Grzesiek Sójka p...@sojka.co To: users@openoffice.org Sent: Tuesday, September 20, 2011 4:48:46 PM Subject: [users] Help with writing macro Hi there. I need to write a macro accepting variable