Using some relatively simple VB coding syntax, you can design a command button or other control option to create a new workbook and export data to it for use in Excel.

How to Create a New Workbook in Excel. In Microsoft Excel, a program packaged with Microsoft Office, you can create databases of information and then make calculations, graphs and charts based on ...