We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Copy data out of a listview

unreal400
unreal400 asked
on
Medium Priority
375 Views
Last Modified: 2012-08-14
I want to be able to copy selected rows  or columns out a listview to the clipboard then be able to paste the resuts into excel and have the data inserted in the colums so it is formatted  the same way

so if the listview is like this
data 1 |  data2  | data 3
row2a |  data2  | data 3
 
I want to be able to highlight those 2 rows in the listview and copy them  then paste them into excel or whatever and have them formatted in the rows and colums that were in the listview.

Is there an easy way to do this?

Kelly



Comment
Watch Question

Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Commented:
Private Sub Form_Load()
    Clipboard.Clear
For i = 1 To 3
    ListView1.ListItems.Add , , "test"
    ListView1.ListItems.Item(i).SubItems(1) = "test1" & i
    ListView1.ListItems.Item(i).SubItems(2) = "test2" & i
Next i
   
    Dim BUFFER
    For i = 1 To ListView1.ListItems.Count
        BUFFER = BUFFER & ListView1.ListItems.Item(i).Text & vbTab & ListView1.ListItems.Item(i).SubItems(1) & vbTab & ListView1.ListItems.Item(i).SubItems(2) & vbCrLf
    Next i
        Clipboard.SetText BUFFER
End Sub
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.