[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-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 se

[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 My

[users] Re: Help with writing macro

2011-09-21 Thread Dennis E. Hamilton
fice.org Subject: [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 o

[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 Johnny Rosenberg
2011/9/21 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

[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 c

[users] Re: Help with writing macro

2011-09-21 Thread Johnny Rosenberg
2011/9/20 Grzesiek Sójka : > 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 help Ca

[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 >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 length