However, by using Visual Basic for Applications, or VBA, you can also create macros or command buttons to perform various printing tasks within Excel much faster and more efficiently.

Click the command button you created on the form. VB6 sends the data from the form to a new Excel spreadsheet using the file name you entered in the code.