Listbox list to create new workbook.

[asyamonique]

Hello,
Is it possible to create a new excel file with listbox list?
Once we click the button it will ask where to save those listbox datas..

 

[Momentman]

Of course it is, it would be good your current set-up and what you intend to achieve

 

[asyamonique]

If anyone help me out will be gladly appreciated.
So far I try this way but it does not work

Private Sub CommandButton6_Click()

Dim ws As Workbook
Dim rng As Range
Dim i As Long
Dim J As Long


Set ws = Workbook.Add
Set rng = ws.Range("A1")
For i = 0 To ListBox3.ColumnCount - 1
For J = 0 To ListBox3.ListCount - 1
rng.Offset(J, i) = ListBox3.Column(i, J)
Next J
Next i


End Sub

Momentman I can PM what I would achieve or not!