I need a VB Code to save a copy of opened sheet 1 as a tab delimited text file (but not overwrite the original), to a specific path.
I think this is close, but there are two issues, the resulting text file is basically jibberish and I would like the original Excel sheet to just close after this is ran, not saved.
Dim sFilename As String, Path As String
sFilename = "filename_" & Format(Date, "yyyy-mm-dd") & ".txt"
Path = "S:\Report_FTP"
'Saving the Workbook
ActiveWorkbook.SaveAs Path & "\" & sFilename
Please let me know if you have any questions.