save as tab delimited file?

[Anonymous]

Part of my program requires saving an excel spreadsheet as a tab delimited
file. Is this possible? I am using ACAD2002. Any sample code would be
great.

Thanks in advance

[Anonymous]

Nevermind - figured it out

"Monica" wrote in message
news:CCCB30413299813787A3D6D5827E1BF0@in.WebX.maYIadrTaRb...
> Part of my program requires saving an excel spreadsheet as a tab delimited
> file. Is this possible? I am using ACAD2002. Any sample code would be
> great.
>
> Thanks in advance
>
>

[Anonymous]

ActiveWorkbook.SaveAs FileName:="MyFile.txt", FileFormat:=xlCurrentPlatformText

[Anonymous]

XlApp.ActiveWorkbook.SaveAs "C:\Temp\Test.txt", FileFormat:=xlTextMSDOS


"Monica" wrote in message
news:CCCB30413299813787A3D6D5827E1BF0@in.WebX.maYIadrTaRb...
> Part of my program requires saving an excel spreadsheet as a tab delimited
> file. Is this possible? I am using ACAD2002. Any sample code would be
> great.
>
> Thanks in advance
>
>