ExcelBanter - Fileformat XLText

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Fileformat XLText (https://www.excelbanter.com/excel-programming/323098-fileformat-xltext.html)

JeepNC

Fileformat XLText

I have some VBA code that saves a worksheet as XLText in Excel 9 but it
doesn't work in Excel 10. It appears that XLText is not a valid file format.
Instead I have the option of XLTextMSDOS, XLTextWindows etc. Does anyone
know which one of these will give me the same file format as the plain XLText
did in version 9?

Tom Ogilvy

Fileformat XLText

xlCSV

--
Regards,
Tom Ogilvy

"JeepNC" wrote in message
...
I have some VBA code that saves a worksheet as XLText in Excel 9 but it
doesn't work in Excel 10. It appears that XLText is not a valid file
format.
Instead I have the option of XLTextMSDOS, XLTextWindows etc. Does anyone
know which one of these will give me the same file format as the plain
XLText
did in version 9?

All times are GMT +1. The time now is 06:52 AM.