I would normally create a csv file as I go. DataToClip will create the data but not headers. I do this a lot to create excel sheets unless I go with automation. scan the table adding values with "," between (dont forget to trim) and dtoc dates and the like to a loacl var. Make you column headers first also with "," between. I make this as a var then stringtofile after. (.csv). This can be read into excel. Note excel buggers up csv files. It replaces dates with its own type for one. Allen
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of tanvir ahmad Sent: 18 January 2008 11:17 To: [EMAIL PROTECTED] Subject: Re: Grid value send to Excel Thanks Dave u'r advice is working very well but my requirement is sent grid value with header caption or report sent to excel. No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.6/1230 - Release Date: 17/01/2008 16:59 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
