Thanks Dave
u'r advice is working very well but my requirement is sent grid value with
header caption or report sent to excel.
On Jan 18, 2008 12:33 AM, Dave Crozier <[EMAIL PROTECTED]> wrote:
> Tanvir,
> If you are using VFP9 (or even 8 I think) then try the following:
>
> Create cursor curTemp (ID C(20), Number N(10,2))
> Insert into curTemp value ("A001", 100)
> Insert into curTemp value ("B001", 200)
> Insert into curTemp value ("C001", 300)
>
>
> Select curTemp
> Application.DataToClip("curTemp",99999,3)
>
> Then load up Excel and past from the clipboard. You can use Office
> Automation to do the pasting under program control if you want to.
>
> CSV stands for Comma Separated Value which is one standard method of
> exporting files from VFP:
>
> Select <<cAlias>>
> Copy to c:\temp.csv type CSV
>
> The csv file can be opened/imported by Excel.
>
> Dave Crozier
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
> Of tanvir ahmad
> Sent: 18 January 2008 05:28
> To: ProFox Email List
> Subject: Re: Grid value send to Excel
>
> i don't understand about word "csv". and
> also "Application.DataToClip(<<cAlias>>,999999,3)".
> plz help me soon with examples.
> On Jan 16, 2008 4:35 AM, Dave Crozier <[EMAIL PROTECTED]> wrote:
>
> > Al and Tanvir,
> > Or
> >
> > Application.DataToClip(<<cAlias>>,999999,3)
> >
> > Which will copy the cursor into the clipboard and you can then use
> > automation or manual cut/paste.
> >
> > Dave Crozier
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf
> > Of Allen
> > Sent: 16 January 2008 10:52
> > To: [email protected]
> > Subject: RE: Grid value send to Excel
> >
> > easiest is to make a csv. Other wise its excel automation.
> > http://www.hentzenwerke.com/catalog/autofox.htm
> > Allen
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > On
> > Behalf Of tanvir ahmad
> > Sent: 16 January 2008 09:31
> > To: [EMAIL PROTECTED]
> > Subject: Grid value send to Excel
> >
> > hi Avery buddy,
> > how to send Any Grid Value with all column value and Heading Caption to
> > Excel. is possible please help me soooooon.
> >
> > No virus found in this outgoing message.
> > Checked by AVG Free Edition.
> > Version: 7.5.516 / Virus Database: 269.19.4/1227 - Release Date:
> > 16/01/2008
> > 01:40
> >
> >
> >
> >
[excessive quoting removed by server]
_______________________________________________
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.
