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.

To import data from a text file into Microsoft Excel, follow this step-by-step guide: First, create a blank spreadsheet in Microsoft Excel and ensure you have the .txt file on your PC.

Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.