Transfer list box items to Excel

[boomstick425]

Hello,

I would like to transport the items I have in a listbox to an excel document. I would like to try the copy and paste method but I really don't know how to set it up. I've also tried the streamreader/writer process but I believe I've written the procedure wrong for that as well. This is the last step to a program I've been working on for a really long time and would appreciate any help at all. Thank you for your time.

Dave

[Phil Weber]

Are you using VB.NET?

[boomstick425]

yes sir

[Phil Weber]

To copy the contents of a ListBox (lstBox) to the clipboard, do this:

' Imports System.Collections
' Imports System.Windows.Forms

Dim alItems As New ArrayList
For Each item As Object In lstBox.Items
    alItems.Add(item.ToString())
Next
Dim sData As String = String.Join(vbCrLf, _ 
    CType(alItems.ToArray(GetType(String)), String()))
Clipboard.SetDataObject(sData)

You may then paste the list into Excel, Notepad, etc. You may also find the following article helpful: http://support.microsoft.com/default...b;en-us;306022