Dear,

I run the following codes, but I can not save the file, and get an error
message. Why?

Dim xlExcelbook As Excel.Workbook
....
xlExcelBook.SaveAs "C:\test.txt", xlTextMSDOS

Err.Number : 1004
Err.Description: Application-defined or object-defined error

I have tested some file format.

They are OK.
xlExcelBook.SaveAs "C:\test.xls"
xlExcelBook.SaveAs "C:\test.htm", xlHtml
xlExcelBook.SaveAs "C:\test.csv", xlCSV
xlExcelBook.SaveAs "C:\test.txt", xlUnicodeText

They can not work, and get an error message.
xlExcelBook.SaveAs "C:\test.csv", xlCSVMac
xlExcelBook.SaveAs "C:\test.csv", xlCSVMSDOS
xlExcelBook.SaveAs "C:\test.csv", xlCSVWindows
xlExcelBook.SaveAs "C:\test.txt", xlTextMac
xlExcelBook.SaveAs "C:\test.txt", xlTextMSDOS
xlExcelBook.SaveAs "C:\test.txt", xlTextWindows

Thanks advance!
Liu jianzhong