https://issues.apache.org/ooo/show_bug.cgi?id=124723
mroe <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |needmoreinfo Status|CONFIRMED |RESOLVED Latest|4.1-dev |--- Confirmation on| | Resolution|--- |NOT_AN_ISSUE OS|All |Windows XP --- Comment #6 from mroe <[email protected]> --- The macro that I recorded accordingly to your description: sub Netbal rem ---------------------------------------------------------------------- rem define variables dim document as object dim dispatcher as object rem ---------------------------------------------------------------------- rem get access to the document document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") rem ---------------------------------------------------------------------- rem dispatcher.executeDispatch(document, ".uno:GoalSeekDialog", "", 0, Array()) rem ---------------------------------------------------------------------- dispatcher.executeDispatch(document, ".uno:GoalSeek", "", 0, Array()) rem ---------------------------------------------------------------------- dim args3(1) as new com.sun.star.beans.PropertyValue args3(0).Name = "By" args3(0).Value = 1 args3(1).Name = "Sel" args3(1).Value = false dispatcher.executeDispatch(document, ".uno:GoRight", "", 0, args3()) end sub The dispatcher API doesn't provide access to all functions of AOO and works other than the macro recording in Excel. But if you only want to call the dialog for the GoalSeek, then simply delete the "rem" before dispatcher.executeDispatch(document, ".uno:GoalSeekDialog", "", 0, Array()) . If you want other results you have to use the Basic API directly. If you need help please look for help at the AOO mailing lists. http://openoffice.apache.org/mailing-lists.html For the first try subscribe to the Users Mailing List. -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
