Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Paste in Excel sheet
Message
De
06/04/2007 10:14:30
 
 
À
06/04/2007 10:06:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01212959
Message ID:
01212960
Vues:
13
This message has been marked as the solution to the initial question of the thread.
>#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

Change addtextbox line to:
losheet.shapes.addtextbox(1, 100, 100, 103.5, 15).TextFrame.Characters.Text = "Boris"
Edward Pikman
Independent Consultant
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform