Can someone tell me the difference between the following XlFileFormat constants:
xlTextMSDOS
xlTextPrinter
xlTextWindows
xlUnicodeText
I am saving an excel spreadsheet using:
ActiveWorkbook.SaveAs Filename:="C:test.txt", FileFormat:= _
xlTextPrinter, CreateBackup:=True
Problem - The resultant file has the rows from the spreadsheet wrapped. Does xltxtprinter have some default linesize? WIll one of the other formats correct this?
Thanks
xlTextMSDOS
xlTextPrinter
xlTextWindows
xlUnicodeText
I am saving an excel spreadsheet using:
ActiveWorkbook.SaveAs Filename:="C:test.txt", FileFormat:= _
xlTextPrinter, CreateBackup:=True
Problem - The resultant file has the rows from the spreadsheet wrapped. Does xltxtprinter have some default linesize? WIll one of the other formats correct this?
Thanks