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 ...

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.