Transfer data from Clipboard to array RRS feed

  • Question

  • Hello,

    Is there a way to transfer from clipboard to array. I want to pass S to array

    Sub Test()

    Dim DataObj As New MSForms.DataObject
    Dim S As String
    Dim TheArray As Variant


    S = DataObj.GetText

    End sub

    Guy Zommer

    Sunday, January 11, 2015 2:49 PM

All replies

  • How best to convert your String to an array will depend on your String, what you anticipate it will consist of,  expected delimiters, whether it should be a 1D or 2D array, etc. The Split function might be helpful, on its own or as part of a parsing routine.
    Sunday, January 11, 2015 4:48 PM