If you are going to venture from CSV to another text file format at all, HTML is very "old school". Excel has supported XML for formatting data for a couple years now and v2003 has extensive support.
Try this in Excel 2002/XP or above: -Open Excel from scratch - put text in a1 - select a1 and b1, then use the merge and center button or menu option - add numeric data to a2, format the cell with a currency mask - add text to b2, click bold and some color like red. - save-as, pull down the extension list to XML, and save as book1.xml Close Excel, re-open, and open book1.xml - exact same info right? Now open book1.xml in notepad. Pure text. Use that file as a template in BASIC, read it, update it, write it. There is your formatted data and you don't need a web designer, or HTML tools. The only XML you need to know about is what you actually want to use, and even then you can get Excel to generate it for you. HTH Tony Nebula R&D http://Nebula-RnD.com/products/analysis.htm http://Nebula-RnD.com/demos/nebulanalysis/ David Beahm wrote: >XML/HTML allow you to specify how something should be imported, vs CSV >which requires manual intervention to prevent annoyances such >as 3-16 (a part number) from becoming March 16th in Excel. The >formatting controls >are a nice bonus. Unfortunately, Excel takes much, much longer when >handling HTML, but since it eliminates so many user issues, >it's what I prefer. YMMV. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
