Launch Visual Basic 6 or Visual Basic Express. Open the project file in which you want to create a module and command button that creates an Excel spreadsheet from selected data.

To enter the procedure, press Alt + F11 to open the Visual Basic Editor (VBE). In the Project Explorer to the left, select ThisWorkbook so you can run the procedure in any sheet.

How to Automatically Convert an Excel File to Text Using Visual Basic. Microsoft's ubiquitous spreadsheet application, Excel, is a useful tool for small and large businesses alike.