Contents
Index 🔎︎

# CreateUnoService Function

Instantiates a Uno service with the ProcessServiceManager.

### Syntax:

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

### Example:

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

### Example:

oIntrospection = CreateUnoService( "com.sun.star.beans.Introspection" )

The following code uses a service to open a file open dialogue:

    Sub Main
        fName = FileOpenDialog ("Please select a file")
        print "file chosen: "+fName
    End Sub

    Function FileOpenDialog(title As String) As String
        filepicker = createUnoService("com.sun.star.ui.dialogs.FilePicker")
        filepicker.Title = title
        filepicker.execute()
        files = filepicker.getFiles()
        FileOpenDialog=files(0)
    End Function

Related Topics

Calling Calc Functions