Which FileFormat code (enumeration) for XL 97-2003 ?

[RonMcK]

I have opend a TXT file and done my text to column conversion. Now, I want to save it in Microsoft Excel 97-2003 format as an XLS file.

Which FileFormat code should I use, xlExcel8 ? (enumeration 56)

Thanks,

[shrivallabha]

There was a very good discussion which I'd used for my own benefit. Hope it helps you as well
http://www.vbaexpress.com/forum/showthread.php?t=35640

[RonMcK]

Thank you very much, Shrivallabha. A very informative thread and some good references.

One important "take away" is to use the numeric fileformats and not the keyword names so one avoids backward incompatibility problems.


Thanks, again,