Debbie Sue,

If you need to save the changes to both the text file and the Excel file, then try

Sub SaveFileToTextFile()
Application.DisplayAlerts = False
ThisWorkbook.Save
ThisWorkbook.SaveAs _
FileFormat:=xlText
ThisWorkbook.SaveAs _
FileFormat:=xlNormal
Application.DisplayAlerts = False
End Sub

HTH,
Bernie
MS Excel MVP


"DebbieSue" wrote in message
...
I have an excel file that I always save as a text file for importing into
another program. I was wondering if a Macro could be made to do this? I have
tried to record the Macro as I do it, but it didn't even save it.