Seems to me you are creating a new worksheet, wsNew in the current workbook.
You then add the data from the listbox to the new worksheet.
Then you have this which creates a new workbook with just that worksheet.
If you want to create a new workbook from a template.![]()
wsNew.Move
![]()
Set wbNew = Workbooks.Add("C:\TheTemplate.xlsm") ' code to add data from listbox to sheet in new workbook ' code to save new workbook
Bookmarks