G
Guest
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
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