Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Fileformat property - Excel VBA

Status
Not open for further replies.

baltaone

Programmer
Feb 14, 2002
3
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top