saving a .xlsx as a tab delimited text file

[Sonican]

I have a spreadsheet that I need to convert into a tab delimited text file.
I am writing some vbs code in notepad++ and I just cant get the last line to work, everything else runs perfect, but I just cant get it to save as a tab delimited text file :/

Set ExcelObject = CreateObject("Excel.Application")ExcelObject.visible = True
ExcelObject.Workbooks.Open"c:\testingblank.xlsx",Default, False
ExcelObject.sheets(1).Rows("1:2").Delete
ExcelObject.Sheets(1).Cells(1,1).value = "testing write function"
ExcelObject.Activeworkbook.SaveAs Filename="C:\output.txt", FileFormat=xl _

The only line that i cant get to work is this

ExcelObject.Activeworkbook.SaveAs Filename="C:\output.txt", FileFormat=xl _

I'm not getting an error message or anything, but instead the code is randomly making another file called "FALSE.xls" and its driving me insane.

 

[StephenCrump]

Filename:= ....

FileFormat:= ...