objWorkbook.SaveAs FileName:="C:\Test.txt", FileFormat:=xlText

This is not working for me.
I get SaveAs method of workbook failed (1004)
I changed x|Text to one of many wdformats they fail too. ex(wdFormatDOSTextLineBreaks )

i need to export the spread sheet after making changes to a tab delimited file.

thanks.