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.
