After creating UserForm1 for one Excel application, you realize that you'll want to use it again -- with a few modifications -- in another application. You do not need to recreate the form; simply ...

VB6 sends the data from the form to a new Excel spreadsheet using the file name you entered in the code. Launch Microsoft Excel and open the new spreadsheet created by the VB6 application.