Question 1:
How should I change the following macro so it that successfully accesses
a function and a subroutine in a different library?
It's not clear to me that my "path" is correct or that my use of square
brackets is done in a way the solves the problem of spaces in the "My
Macros & Dialogs" portion of the "path."
sub Main
rem ----------------------------------------------------------------------
rem define variables
Dim SheetName$, Addr$
rem get sheet name
SheetName$ = [soffice.My Macros & Dialogs.Calc.CellOps.Sheetname]
print SheetName$
' goto address appropriate to sheet -- default= A1 (0,0)
Addr$ = "A1"
If Sheet$="Fund Ratings" Then
Addr$ = "E9"
EndIf
Call [soffice.My Macros & Dialogs.Calc.CellOps.SelectAddr( SheetName$,
Addr$ )]
end sub
Question 2:
Where in the macro library structure should a Basic macro-function be
located in order for it to be used directly in a spreadsheet cell, ala
the Wahoo function in Andrew Pitonak's book "OpenOffice.org Macros
Explained", p. 368?
Question 3:
Is there a different list that I should have submitted the above
questions to? I'm sure that many, many OOo users have no interest in
such matters.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
