Here’s an example of VBA code that writes data to a text file:
Sub WriteDataToTXT() Dim filePath As String Dim fileNumber As Integer Dim rowData As String ' Specify the path and filename of the text file filePath = "C:\Path\to\your\File.txt" ' Specify the data to be written to the text file rowData = "Hello, World!" ' Replace with your data ' Open the text file for writing fileNumber = FreeFile Open filePath For Output As fileNumber ' Write data to the text file Print #fileNumber, rowData ' Close the text file Close fileNumber End Sub
In this code, you need to modify the filePath variable to the actual path and filename of your text file.
The rowData variable contains the data you want to write to the text file. You can customize it according to your requirements. The example provided writes the string “Hello, World!” to the text file.
When you run this code, it will open the specified text file for writing, write the data to the file, and then close the file.
Note: Make sure that the specified path is valid and that you have the necessary write permissions to create and modify files in that location.