Thanks to all of you, I tried the DIF option and that seems to work better. I saved the resulting file as .xls so it is OK for now. I actually saw a nicely formatted example in Razzak's sample application. Tried to use similar code but could not get it to work at all. Wish I could get it to work like his. It is magical. Robert
-----Original Message----- From: KarenTellef <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Fri, Nov 25, 2011 12:40 pm Subject: [RBASE-L] - Re: Creating Excel FIles Robert: It's difficult to get right, alot of trial and error. However, try the Data Exchange Format (DIF). Excel will bring these up. The only thing it doesn't bring over well is memo fields, but it's done a much better job for me. You just don't get the .xls extension. Karen In a message dated 11/24/2011 11:50:37 AM Central Standard Time, [email protected] writes: This is just not working for me: Create a report with columns across the form, no headings etc., plain text. data. (Even converted a note to text). Print the report which displays on screen, select file output and choose the Excel option. The Excel file generated is all messed up, has even two of the columns in the same cells and several not displayed at all. Tried lots of stuff but no luck. Thanks for any advice. Robert A.
