1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| Sub Macro2() ' test envoie d'une liste à Applescript
Dim myAS As String, MyPaths As String, PP As New MSForms.DataObject
CR = Chr$(13)
GU = Chr$(34)
Sep = "," ' virgule comme séparateur de liste
'vbalist = GU & "test1" & GU & Sep & GU & "test2" & GU & Sep & GU & "Test3" & GU ' prepare la liste
DL = Cells(Rows.Count, 2).End(xlUp).Row
vbalist = """" & Join(Application.Transpose(Application.Index(Range("B1:B" & DL).Value, 0, 1)), """, """) & """"
' construit le script AS
myAS = "set ASList to " & "{" & vbalist & "}" ' la varialbe ASList est une liste dans Applescript
myAS = myAS & CR & "set text item delimiters to " & GU & "," & GU
myAS = myAS & CR & "return ASList as text" ' renvoie de AS vers VBA de la liste
'myAS = myAS & CR & "set the clipboard to ASList as Unicode text"
MyPaths = MacScript(myAS) ' retour dans VBA dans la variable ListeRetour
'PP.GetFromClipboard: MyPaths = PP.GetText(): Recup = Split(MyPaths, ",")
Recup = Split(MyPaths, ",")
Cells(1, 4).Resize(UBound(Recup)) = Application.Transpose(Recup)
End Sub |
Partager