Excel SaveAs "TXT" file

[Anonymous]

I'd like to open and excel file and save it as a text file using VBA. I
know how to open the file and saveas ".txt", but it's still the Excel "XLS"
format. What I really want is to save it to a ".txt" file with TAB
delimitation. Does anyone know how to do this? I would appreciate any help
to push me in the right direction.

Thanks,
JC

[arcticad]

save the file as a cvs file

[Anonymous]

you need to specify the file format after specifying the filename ~ just specifying a file name is not enough
e.g.
XL.ActiveSheet.SaveAs "C:\data\myfile.csv", xlCSV
will save as CSV format ~ I can't remember what the Text version is offhand, it may be xlUnicodeText

http://www.resourcecad.com ~ for your CAD solutions

[Anonymous]

To save as Tab Delimited just seperate your values with
a Tab.

Private Sub stub()
Dim txtTab As Integer: txtTab = FreeFile
Open "c:\TabDelimited.txt" For Output As #txtTab
Print #txtTab, "1" & vbTab & "2" & vbTab
Close #txtTab
End Sub

Replace vbTab with "," and give file a .csv ext for
csv file type.

gl Paul

[Anonymous]

why write all the tabs manually when the saveas will do it automatically for you ? you are just creating unnecessary work for your self

[Anonymous]

use this method if your not in Excel VBA...