PDA

View Full Version : Which FileFormat code (enumeration) for XL 97-2003 ?



RonMcK
03-29-2011, 07:56 AM
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
03-29-2011, 08:41 AM
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
03-29-2011, 09:11 AM
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,