CreateUnoService Function

Instantiates a Uno service with the ProcessServiceManager.

oService = CreateUnoService( Uno service name ) For a list of available services, go to: https://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star.html

Calc functions;API Service Calling Calc functions in Basic:

REM The code below does not work for add-in functions, which have a different calling procedure. Function MyVlook(item, InRange As Object, FromCol As Integer) Dim oService As Object oService = createUnoService("com.sun.star.sheet.FunctionAccess") REM Always use the function English name MyVlook = oService.callFunction("VLOOKUP",Array(item, InRange, FromCol, True)) End Function

oIntrospection = CreateUnoService( "com.sun.star.beans.Introspection" ) filepicker;API service The following code uses a service to open a file open dialog: Sub Main fName = FileOpenDialog ("Please select a file") Print "file chosen: "+fName End Sub Function FileOpenDialog(title As String) As String res = com.sun.star.ui.dialogs.ExecutableDialogResults filepicker = createUnoService("com.sun.star.ui.dialogs.FilePicker") filepicker.Title = title If res.OK = filepicker.execute() Then files = filepicker.getSelectedFiles() FileOpenDialog=files(0) EndIf End Function