On 6/12/2010 4:00 AM, Harrie Borgers wrote:
L.S
A novice's requires
Where can I read more about: args(0)
This looks like something you found in macro you recorded in Calc. I
don't know that you can read much about it that can be generalized. I
think it's just a variable name created by the macro recorder, and that
you're pretty much limited to changing the value assigned to it. For
example, here is a macro I generalized from a recorded one:
sub GoLeft( optional X as variant )
rem ----------------------------------------------------------------------
rem define variables
dim document as object
dim dispatcher as object
rem get access to the document
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
dim args6(1) as new com.sun.star.beans.PropertyValue
args6(0).Name = "By"
If IsMissing( X ) Then
args6(0).Value = 1
Else
args6(0).Value = X
EndIf
args6(1).Name = "Sel"
args6(1).Value = false
dispatcher.executeDispatch(document, ".uno:GoLeft", "", 0, args6())
end sub
The lines starting "args6(0).Value = " are the ones that show
generalization. Everything else is just used verbatim. I think you
would need to be a Sun systems programmer, or someone with an equivalent
knowledge level to do other sorts of things.
How to call - in basic - a second spreadsheet with variable name
What do you mean by "call"; do you mean read the contents of a
particular cell or cells?
How do I read out the value of cell(3,4) for calculation
This involves use of a number of functions and procedures. I have
written a set of these that meet my needs; they are based on Andrew
Pitonyak's book and other publications, which I would urge you to get if
you haven't already. Be prepared for some computer-science level stuff,
though. I could send you my library by private email if you decide you
want to pursue this.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
