>I need to copy a field from a table and paste it into either Word
>or Excel document being opened.
>
>I used _CLIPTEXT = ALLTRIM(table.field) to copy into memory.
>How could I paste it "automatically" on where the last cursor being
>placed on the Word/Excel document? Could anyone share with me on the
>links needed and the syntax to paste, please. Thank you very much.
Hi Alvin,
In addition to what the others have mentioned, you can store multiple fields and records by using the DataToClip() method. While I haven't experimented with it using OLE automation, interactively, if you use 3 as the data format parameter, the field names, and data will be copied directly into individual cells in an Excel spreadsheet.
hth,
George
Ubi caritas et amor, deus ibi est