Macro pour coller du texte non formaté du presse-papiers

From The Document Foundation Wiki
Jump to: navigation, search
This page is a translated version of the page Macros/General/008 and the translation is 33% complete.

Other languages:
English • ‎français


Cette macro vous permet de coller du texte non formaté à partir du presse-papiers.


Option Explicit

Sub ClipboardTest
    MsgBox getClipboardText
End Sub ' ClipboardTest

Function getClipboardText() As String
    '''Returns a string of the current clipboard text'''

    Dim oClip As Object '
    Dim oConverter As Object '
    Dim oClipContents As Object
    Dim oTypes As Object
    Dim i%

    oClip = createUnoService("")
    oConverter = createUnoService("")
    On Error Resume Next
    oClipContents = oClip.getContents
    oTypes = oClipContents.getTransferDataFlavors
    For i = LBound(oTypes) To UBound(oTypes)
        If oTypes(i).MimeType = "text/plain;charset=utf-16" Then
            Exit For
        End If
    If (i >= 0) Then
        On Error Resume Next
        getClipboardText = oConverter.convertToSimpleType _
    End If

End Function ' getClipboardText

ODT file to test macro