excel vba save file txt
' Needs to add "Microsoft Scripting Runtime" reference to your file
Public Sub SaveTextToFile(ByVal pFile As String, ByVal pText As String)
Dim fso As FileSystemObject
Dim fileStream As TextStream
Set fso = New FileSystemObject
Set fileStream = fso.CreateTextFile(pFile)
fileStream.WriteLine pText
fileStream.Close
End Sub
' -----------------------------------------------------------------------
Sub TestMe()
SaveTextToFile "C:\Temp\export.txt", "A sentence to be saved..."
End SubAre there any code examples left?
New code examples in category VBA
Relative searches
excel vba save as
vba excel save the file with new file
vba excel save as new file
vba excel save file
vba excel save
Excel vba save file as txt
create and save excel file in vba
excel vba+save file
excel vba save as new file
excel vba write file
excel vba save worksheet as new file
excel vba write to text file
vba save text file
Excel vba can you save as a text file?
vba save file
vba code save worksheet
vba macro save excel file
vba macro save file
excel vba file save as
excel vba save file formats
save new excel file vba
vba code for save excel file
vba save to file
excel vba save file txt
