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,
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.