Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Paste into Word/Excel
Message
De
19/05/1999 03:49:32
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
18/05/1999 22:39:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00220285
Message ID:
00220312
Vues:
30
>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.
_cliptext = "testpaste"
oExcel = createobject("Excel.application")
WITH oExcel
  .workbooks.add && Add a new workbook
  WITH .activeworkbook
    .activesheet.paste
  ENDWITH
  .visible = .t.
ENDWITH

oWord = createobject("Word.application")
WITH oWord
  .documents.add
  .selection.paste
  .visible = .t.
ENDWITH
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform