How to Write Multiple Rows to Excel Using Vb.Net. When building Visual Basic.Net applications, consider adding an export to Excel feature in addition to printed reports. The added functionality ...

Launch Excel and click the "Developer" tab above the ribbon menu; then click the "Visual Basic" button. Type "Sub ConvertToText ()" (without quotation marks) into the code pane.

And although VBA is installed by default, accessing the Visual Basic Editor (VBE), through which you’ll enter your VBA code, doesn’t automatically appear in the Ribbon.