Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Paste in Excel sheet
Message
De
06/04/2007 10:06:24
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Paste in Excel sheet
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01212959
Message ID:
01212959
Vues:
57
#define true .t.
#define false .f.
#define msotextorientationhorizontal 1

local oexcel as excel.application
oexcel = createobject([Excel.Application])
oexcel.workbooks.add()

with oexcel
for each losheet in .activeworkbook.sheets
losheet.activate
losheet.range('A1').select
losheet.range("A2").value ="Boris"
losheet.shapes.addtextbox(msotextorientationhorizontal, 100, 100, 103.5, 15).select
&& Here in this textbox1, I want to add value of "A2" i.e. Boris
endfor
endwith
oexcel.visible=.t.

Please help
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform