output excel to text file

I need to write data to a text file as a data steam I have written preliminary code to capute data in a spreadsheet but the ultimate goal is to write the data direct to a text file without using a spreadsheet. currently the spreadsheet is just to verify that the data is being captured correctly...

Hi Macro Experts!!! I need help creating a macro that will save a range (F#:DD#) based on the supplier value in column C as a text file. I included a screenshot of what my spreadsheet set up looks like. I need a separate text file for each supplier (Column C) that contains all of the data...

Greetings, I have used the following two codes in an attempt to output excel to a text file: 1. Sub Output() Dim myFileName As String myFileName = InputBox("Name Your Output File") Range("B126").Value = myFileName If myFileName = "" Or Range("B126") = "" Then Exit Sub End If Open...