I found an answer.
Worksheets("sorted").SaveAs Filename:= _
So now the worksheet/workbook when saved as tab delimited updates the "sorted" worksheet to the tab delimited name.
I really want to save the tab delimited file, but don't need to update my worksheet name. I can just leave it named "sorted".
Right now I have to close the workbook without saving:
'ThisWorkbook.Close savechanges:=False 'true ???
Then open it again manually.
Is there a way around this?
Here is my macro:
ChDir "K:\Data"
Application.DisplayAlerts = False
Worksheets("Sorted").SaveAs Filename:= _
"K:\Data\MyFile.txt", _
FileFormat:=xlText, ReadOnlyRecommended:=False, CreateBackup:=False
Application.DisplayAlerts = True
ChDir "K:\Databases and Logo Lists for Site"
ThisWorkbook.Close savechanges:=False
Bookmarks