Save Excel File into a Tab-Delimited File - by MACRO

[Robb]

I need to save an excel file into a Tab-Delimited file...programmatically. This needs to be done so Unix can read the file and do wonderful things with the data.

I use an Excel WB to Open a file that the user would like to format. Once the formatting is done I need to close the file but save it as a tab-delimited file in a different location - all without user intervention. I don't need to save the changes on the original Excel file.

 

[Mark O'Brien]

Something as simple as this would work:

<pre>
Option Explicit


Private Sub SaveAsTabDelimited(ByVal sFileName As String)
With ActiveWorkbook
.SaveAs Filename:=sFileName, FileFormat:=xlText, CreateBackup:=False
End With
End Sub

Public Sub test()
SaveAsTabDelimited "C:TempBook2.txt"
ActiveWorkbook.Close savechanges:=False
End Sub</pre>

You might want to add something that makes sure the filename is unique though.

HTH

 

[Robb]

Thanx Mark, works like a charm. Funny how sometimes we over analyze things.